Dumb Question, how to insert ' into varchar2 field

Don't ask why but I have a need to insert a ' symbol into a varchar2 field. Replacing ' with something else is not option.

I have tried escaping it:

insert into user.table values ( 'some text containing \'. some more text' )

Oracle complains about the ' symbol (ORA-00917).

What is the proper way to 'escape' this symbol so I can store it into a varchar2 field?

much thx Received on Tue Feb 15 2005 - 10:10:19 CST