Re: How can I use '&' in VARCHAR2 fields ?

From: <vishants_at_my-deja.com>
Date: Fri, 20 Oct 2000 19:43:23 GMT
Message-ID: <8sq78n$mja$1@nnrp1.deja.com>

pl do the following

set escape \
insert into
INSERT INTO mytlb (myfield) VALUES ('/mypage.asp? par1=345\&par2=234')

In article <8snk8h$ifl$1_at_nnrp1.deja.com>,   oracle4444_at_my-deja.com wrote:
> In article <8sn6k1$9do$1_at_nslave3.tin.it>,
> "rdf" <deficis_at_show.it> wrote:
> > Hi,
> >
> > I think the subject is all...!!!
> > My example:
> > INSERT INTO mytlb (myfield) VALUES

 ('/mypage.asp?par1=345&par2=234')
> >
> > I hope in your help.
> > Thanks.
> >
> ------------------------------------------------

---

>
> The easy solution is SET SCAN OFF
>
> try following:
>
> SET SCAN OFF;
> INSERT INTO mytlb (myfield) VALUES

 ('/mypage.asp?par1=345&par2=234');
>
> should work fine
>
> hope this helps
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 20 2000 - 14:43:23 CDT