Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Ampersand &

Re: Ampersand &

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Wed, 07 Jul 2004 10:05:26 -0500
Message-ID: <40EC1136.B062CA15@ram.lmtas.lmco.com>


Yes that is correct .... That works great ..thanks,

Mike

Romeo Olympia wrote:
>
> I am a little confused by what you want done.
>
> Are you saying that you have values in a column that has ampersands
> '&' (eg. 'value1&', 'blah&')? And that you want to replace these with
> '&amp;' in the query output? You're using SQLPLUS aren't you?
>
> If so, then you're having a bit of a mix-up with the default
> substitution variable &. You need to do this (in sqlplus):
>
> SET ESC \
>
> SELECT REPLACE(col1, '\&', '\&amp;')
> FROM mytable;
>
> Or I could have gotten your question all wrong in which case this post
> probably is just another scrambled egg.
>
> Michael Hill <hillmw_at_ram.lmtas.lmco.com> wrote in message news:<40EB15C0.F0A15C7A_at_ram.lmtas.lmco.com>...
> > I have a field that has an ampersand in it: "&" that I'd like to convert
> > to "&amp;".
> >
> > I'd like to do the conversion right in the select query instead of after
> > the query returns rows and I am looping through them.
> >
> > Any ideas are appreciated.
> >
> > Mike
Received on Wed Jul 07 2004 - 10:05:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US