Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ampersand embedded in a string
set define off
or
set define (some other character)
Narendra Puppala wrote in message <7pd57q$6s4$1_at_ionews.ionet.net>...
>Well, it depends on what exactly you need. If you want to have an
ampersand
>as part of your column name, I believe this is not possible.
>
>If you want to have an & embedded as part of the value entered for a column
>then you can do the following to avoid SQL* PLUS from interpreting the &.
>
>set scan off;
>
>This setting is valid only for your current session.
>
>Nandakumar wrote in message <7pcp5s$oum$1_at_nnrp1.deja.com>...
>>Can we include & in a varchar2 field (of a table) without causing a
>>problem in queries?
>>Any Escape Sequence required before &??
>>--
>>Nandakumar
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Share what you know. Learn what you don't.
>
>
Received on Wed Aug 18 1999 - 19:11:10 CDT