try something like '||'&'||' it seems to work correctly
SELECT FES_LONG_DESCRIPTION From VERIFIERS
> > WHERE LOW_VALUE)='MO'||'&'||'TU' AND VERIFIERS.RV_DOMAIN)='DAYS';
"Rob Sinn" <robsinn_at_home.pipex.com> a écrit dans le message news:
3c077b94$0$231$cc9e4d1f_at_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 - 09:44:22 CST
