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