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

[Guest]

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');

ERROR:
ORA-01756: quoted string not properly terminated

How else do you do this?

[Newsgroups]

jeffchirco@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?

[Guest]

Thanks, I thought I tried that, but I guess not.