By default, SQL*Plus uses ampersand for substitution variable. You can use
"set define" command to change it to any other character (like '|', etc.)
"Stéphane Martel" <martste_at_cognicase.ca> wrote in message
news:9OnH4.4527$HG1.128422_at_nnrp1.uunet.ca...
> you can also use 'Sound'||' & '||'Music'
>
> Stéphane Martel
> (418) 877-4615 poste 22
> Cognicase Technologie Internet
> Une division de Cognicase inc.
> site : http://www.cognicase.ca
> courriel : mailto:stephane.martel_at_cognicase.ca
>
>
> "Michael C. Wilkerson" <Mike.Wilkerson_at_uscreative.com> a écrit dans le
> message news: 38EE0041.A50C321F_at_uscreative.com...
> > Is there any way to escape an & in a string?
> >
> > If I attempt to insert 'Sound & Music', Oracle always prompts me for the
> > value of Music
> > because it thinks I'm specifying a variable.
> >
> > It will work if I break the string up into 'Sound ' || chr(38) || '
> > Music' but I was hoping someone could give me
> > an easier way.
> >
> > Thanks,
> > Michael
> >
>
>
Received on Fri Apr 07 2000 - 13:09:32 CDT
