Quotes in a SQL Statement

[tlarese]

I am trying to run the below statement so I can include the quotes and I am getting an invalid column name message. I tried the script without using quotes and it works fine. What am I missing?

update deltek.empl set cont_name_1 = "BARBARA O'BRIEN" where empl_id = '081575';

[LKBrwn_DBA]

You need to use two single quotes:

update deltek.empl 
     set cont_name_1 = 'BARBARA O''BRIEN'
 where empl_id = '081575';

[tlarese]

Perfect! Thank you VERY much.

[WilliamR]

Or in 10g:

UPDATE deltek.empl
SET    cont_name_1 = q'|Barbara O'Brien|'
WHERE  empl_id = '081575';

download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements003.htm