Re: newbie insert question using replace function

If you are having compilation problems type 'SET DEFINE OFF' before trying to compile something with an ampersand.

Daniel Morgan

Roman Mirzaitov wrote:

> Hi,
>
> try the following:
> update <table>
> set field1 = replace(field1,'&','and')
> where field1 like '%&%';
>
> Regards,
>
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
>
> "Paul Fell" <novaweb_at_iinet.net.au> wrote in message
> news:4b270a4e.0204091911.6c80b291_at_posting.google.com...
> > I'm trying to use the replace function in plsql. I'm new to Oracle.
> > Here's what I want to do :
> >
> > update <table>
> > set field1 = replace(field1,"&","and")
> > where field1 = "&"l
> >
> > I get a compilation error. Should I be using a cursor and feeding the
> > variable inot the replace function?
> >
> > tia
> > Paul
Received on Wed Apr 10 2002 - 10:05:17 CDT