problem with UPDATE

I have a column "credit/debit" in a table named "bank"
the data type for this column is VARCHAR2(25)

I tried to update the row by altering the value of the column "credit/debit"

my query was :

UPDATE BANK
SET CREDIT/DEBIT = 'YES'
WHERE FIRST_NAME = 'LUKE'

but i get the error

ORA-00927: missing equal sign

wat to do ?

thanx

 

You need to enclose CREDIT/DEBIT in quotes otherwise Oracle will think this is an expression, i.e. CREDIT divided by DEBIT, and this is wrong syntax because CREDIT should be followed by an equals not a divide, hence the error.

 

I had been trying to enclose it in single quotes only but as soon as i enclosed it in double quotes the command completed sucessfully.

thanx buddy