From: Yannick KERMABON <y.kermabon@tegelog.fr>
Subject: Re: using & in a string.
Date: 2000/08/08
Message-ID: <398FC201.848D5D50@tegelog.fr>#1/1
Content-Transfer-Encoding: 8bit
References: <398f339d@news> <398F1790.7EEEB42B@t-online.de>
X-Accept-Language: fr
Content-Type: text/plain; charset=iso-8859-1
X-Complaints-To: abuse@fr.uu.net
X-Trace: reader1.fr.uu.net 965723016 11607 213.11.76.1 (8 Aug 2000 08:23:36 GMT)
Organization: TEGELOG
Mime-Version: 1.0
NNTP-Posting-Date: 8 Aug 2000 08:23:36 GMT
Newsgroups: comp.databases.oracle.misc


If you don't need variable in your scripts under sqlplus you can also type :
set define off

Yannick

Stefan Roesch a écrit :

> If you are executing this command from sqlplus than it is clear. The &
> character is used as the beginning of a variable. If you want to enter this
> character than you have to redefine this character with escape command
>
> Hope this helps
> Stefan
>
> Patrick Joyal wrote:
>
> > Hi,
> >
> > I have a string that says : 'Front & back'
> > I want to insert that string into a table :
> >
> > Insert Into Table1 (Description) values ('Front & back') ;
> >
> > resulting in :
> >
> > old   1: Insert into table1 (Description) values ('Front & back') ;
> > new   1: Insert into table1 (Description) values ('Front ') ;
> >
> > 1 row created.
> >
> > My questions are :
> > 1- Why this is happening?
> > 2- How can I avoid that?
> >
> > (I found something for question number 2, but let see if you can come with
> > something better.)
> >
> > thanks
> >
> > Patrick
> >
> > --
> >
> > "She just love my big 10 inch
> >  record of her favorite blues"  - S.T.