Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: using & in a string.
what's an escape command?
Stefan Roesch wrote in message <398F1790.7EEEB42B_at_t-online.de>...
>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