-
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
-
Use two single quotes before the letter m.
insert into test values(2,'I''m good','n','n','o1-Oct-02');
-
Victoria, thank you very much!
-
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.
-
Does anyone have any suggestions?
-
hi try this
insert into test values('I'||CHR(39)||'m good')
where CHR(39) is '
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|