Re: Where clause containing Ampersand

From: James Alexander Starritt <james_at_jamesstarritt.com>
Date: Tue, 18 Dec 2001 09:27:15 -0600
Message-ID: <9vnnfr$ghhjm$1@ID-68406.news.dfncis.de>

Roger,

Thanks, I appreciate it.

James

"Roger Stapley" <roger.stapley_at_oracle.com> wrote in message news:3C1F5BBC.5A25BD85_at_oracle.com...
> either set define off and verify off so it wont ask for it or use select
'Jay
> '||chr(38)||' Silent Bob' from dual;
>
> James Alexander Starritt wrote:
>
> > I have a where clause that contains an & as part of it. Oracle prompts
for
> > a value, assuming that this is a variable. How do I put a literal
ampersand
> > in my where clause.
> >
> > update table
> > set field = 'New Text'
> > where field = 'Jay & Silent Bob';
> >
> > Any ideas. Should be easy as pie but I can't figure it out
> >
> > --
> >
> > James Starritt
>
Received on Tue Dec 18 2001 - 09:27:15 CST