Re: Ampersand sign in a string

HI there

in sqlplus, type the following command and execute the statement

set define ^

(basically you are changing the default define character (&) to some other character) and execute the statement

regards

N.Prabhakar

Galina <Galina.Self_at_cityofbristol.ac.uk> wrote in article <af2b7239.0111300320.713af654_at_posting.google.com>...
> Hello
>
> I have Oracle SQL:
> SELECT FES_LONG_DESCRIPTION From VERIFIERS
> WHERE LOW_VALUE)='MO&TU' AND VERIFIERS.RV_DOMAIN)='DAYS';
>
> The ampersand in the middle of the criteria string causes Oracle asking:
> "Enter value for tu:"
>
> How can I make this SQL so that 'MO&TU'
> is taken as a whole?
>
> Thank you.
> Galina
>
Received on Sat Dec 01 2001 - 19:05:48 CST