insertion with value " ' "

[Unna]

Hi all,

I tried to insert into table with value containing character " ' ", and ran into error.

**************************************************

SQL> insert into test values(2,'I'm good','n','n','o1-Oct-02');
ERROR:
ORA-01756: quoted string not properly terminated

**************************************************

How can I insert alone with the character " ' "? Thanks for your help!

WU

[Victoria]

Use two single quotes before the letter m.
insert into test values(2,'I''m good','n','n','o1-Oct-02');

[Unna]

Victoria, thank you very much!

[Unna]

I still have problem with the " ' ". Using " " " instead of " ' ",

insert into test values(2,'I''m good.','n','n','01-Oct-02');

if I do select * from test, it displays: I'm good. However, if I try to pull this data from web browser, it displays: I"m good. instead. Is there other way to insert this " ' "?

Thanks.

[Unna]

Does anyone have any suggestions?

[balajiyes]

hi try this

insert into test values('I'||CHR(39)||'m good')

where CHR(39) is '