Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help in SQL Plus
Yes, it can be done.
E.g.
string to be inserted abc"de'f
Query:
insert into field_name values('abc"de''f')
In article <Df3P3.382$ZP3.160395_at_news-west.eli.net>,
"Pat Sinthusan" <pat.sinthusan_at_ci.seattle.wa.us> wrote:
> I would like to insert the text into the varchar field. The text
contain
> both ' and " characters. Is there a way to issue SQL statement
without
> doing the replace.
>
> Thanks
>
>
--
Owais Anjum
Senior Software Engineer
Kaps Computing, Pakistan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 20 1999 - 02:07:36 CDT