Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Answer to "&" query
In article <3422A808.1F9A_at_bigfoot.com>,
mike.chan_at_bigfoot.com wrote:
>
> Below is the answer to those users which want "&" to be
> interpreted as it is instead of asking for a value.
>
> in SQL*PLUS,
> set escape /
>
> select ..... where .... = 'A/&B';
>
> Pls let me know if it works
An alternative would be:
in SQL*PLUS
set scan off
select ..... where .... = 'A&B';
Bob England
rengland_at_apci.net
rengland_at_fvh.gtegsc.com
GTE Government Systems
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Fri Sep 19 1997 - 00:00:00 CDT