problem with UPDATE

cerebrum's Avatar
Go4Expert Member
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
0
xpi0t0s's Avatar, Join Date: Aug 2004
Mentor
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.
0
cerebrum's Avatar
Go4Expert Member
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