Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: using & in a string.
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.
Received on Tue Aug 08 2000 - 00:00:00 CDT