Re: insert varchar containing single quote (apostrophe) into oracle???

jeffchirco_at_gmail.com wrote:
> How do I insert a string value into Oracle that contains a single quote
> (apostrophe). Say I want to enter Jeff's into the database. I tried
> using escape character like;
>
> insert into table1
> values ('Jeff\'s');

'Jeff''s'

>
> ERROR:
> ORA-01756: quoted string not properly terminated
>
> How else do you do this?
>
Received on Tue May 17 2005 - 00:08:44 CEST