SET DEF OFF
Richard Gowan wrote in message ...
>
>
>It's also possible to tell SQL*Plus to ignore the &. I can't remember the
option, but it'll be under the online help
>for keyword SET.
>
>
>Regards,
>
>Richard Gowan
>
>
>
>
>DBAOracle wrote:
>>
>> I assume you are doing this in sql*plus, where the & represents a
variable.. to
>> get around the problem you have to do this:
>>
>> insert into table
>> (col1)
>> values
>> ('this is a test'||'&'||'this is not');
>>
>> Note that you seperate the & into it's own
>> quotes and cat it to the other
>> values.
>>
>> Robert
Received on Sun Aug 01 1999 - 23:17:04 CDT
