pl/sql column name is name, cannot use update statement
Posted on 2011-04-22
Is there a way to wrap the name of the column in pl/sql for Oracle 9i?
I have this table that has a column name NAME. The select statement is ok, but the update statement gives me invalid identifer error. If I put single quote around it, it doesn't compare the condition where name = 'abc' correctly. What can I do other than alter the name of the column and alter back? Thanks.