Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q:How to insert string including the quotation mark into a column ?thanks!
You just need one more quotation mark!
sql>desc temp
aaa number(2)
bbb varchar2(10)
sql>insert into temp
values(1, 'cc''c');
"Christian Lee" <stlees_at_yeah.net> wrote in message
news:8vicvs$29cp$1_at_news.cz.js.cn...
> Q:How to insert string including the quotation mark into a column ?thanks!
>
>
>
>
>
>
Received on Thu Nov 23 2000 - 02:19:30 CST