Re: Ampersand sign in a string

From: Rob Sinn <robsinn_at_home.pipex.com>
Date: Fri, 30 Nov 2001 12:27:38 -0000
Message-ID: <3c077b94$0$231$cc9e4d1f@news.dial.pipex.com>

I take it that you are referring to SQLPlus ? You need to set the environment variable 'define' to something other than '&'.

Rob

"Galina" <Galina.Self_at_cityofbristol.ac.uk> wrote in message news: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 Fri Nov 30 2001 - 06:27:38 CST