Re: AMPERSAND in where clause mistaken for variable name

djose_at_att.com wrote:
>
> Hi everyone,
>
> I have a query which is as follows
>
> SELECT
> column_1,
> column_2
> FROM
> table
> WHERE
> column_3 = 'ABC&DEF';
>
> The problem is 'ABC&DEF' represents a value in the table, but because of
> the ampersand oracle mistakes it for a variable which has to be input
> and prompts me for DEF.
>
> My question : Is there a way to make oracle understand that 'ABC&DEF' is a
> data value in the column and not prompt me for DEF.
>
> Any input would be very much appreciated.
>
> Thanks for your time and have a good day.
>
> regds,
> Jude
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

One workaround would be to issue the sqlplus command: set scan off Received on Thu May 15 1997 - 00:00:00 CDT