Re: HELP - How can Oracle accept the '&' character in a string???

From: Kelly Cox <kmcox_at_alum.mit.edu>
Date: Sat, 30 Sep 2000 03:44:38 GMT
Message-ID: <39D5650C.C1D4EF00@alum.mit.edu>

You must be using SQL*Plus. The & is not really a special character to Oracle, but it is to SQL*Plus. It is used to "DEFINE" or indicate a local variable. You may not need it at all for what you're doing.

The Big Secret: SET DEFINE OFF

Then run your script. If you do have local variables in the script as well, you'll need to SET DEFINE to another character and use that in the script.

--Kelly Cox

gmei_at_my-deja.com wrote:

> Try '\&' or use oracle's chr function
>
> In article <8r29nq$5qv$1_at_kermit.esat.net>,
> "Jenny O'Brien" <jennyob_at_peregrine.ie> wrote:
> > Hi,
> >
> > I'm trying to populate an Oracle database with a string containing and
> > ampersant ('&' character). Do you have any ideas?? I've tried
enclosing it
> > in double and singe quotes and I've tried '&&' but no luck !
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> > Jenny
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 29 2000 - 22:44:38 CDT