Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help in SQL Plus

Re: Need help in SQL Plus

From: Owais Anjum <owais_anjum_at_my-deja.com>
Date: Wed, 20 Oct 1999 07:07:36 GMT
Message-ID: <7ujpnj$la3$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US