Re: how to enter '&' in oracle table

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: 2000/05/12
Message-ID: <8fhd2l$a5b$1_at_news.inet.tele.dk>#1/1


Or "set scan off" which stops SQL*Plus scanning for variables.

HTH. Finn

Mike Dwyer <dwyermj_at_co,larimer.co.us> wrote in message news:rUVS4.141$U51.25252_at_wdc-read-01.qwest.net...
> If you are in sql*plus, try
> set define #
> before you do your insert.
> (You may need to pick a different character than #, and you may need to
 set
> the define character back to & after you're done.)
>
> <dksharma_at_my-deja.com> wrote in message
 news:8fh5st$1uk$1_at_nnrp1.deja.com...
> > i want to enter '&' and a part of my varchar2 field value. oracle
> > consider it as if i m passing parameter through it. help me how to enter
> > a fileld value containg '&'
> >
> > regards
> >
> > d k sharma
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri May 12 2000 - 00:00:00 CEST

Original text of this message