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