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

Home -> Community -> Usenet -> c.d.o.server -> Re: special character - '&'

Re: special character - '&'

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Tue, 25 May 1999 14:03:11 GMT
Message-ID: <374AAECF.F4C0D464@sympatico.ca>


It's not a bug.... '&' is SQL*Plus "define" character.

You can change this define character by issuing a "set define ~" which will change it to a "~" instead.

Regards

Marc Mazerolle
InforMaze Technologies Inc.

Nobody you know wrote:

> I previously posted a question about the '&' character embedded in
> data, which seemed to defeat anything I tried, until I wrote a PL/SQL
> stored procedure, which could handle it. Even so, I ran into yet
> another problem with this character -- it causes problem EVEN IN A
> COMMENT. Try it (Oracle 7.4)! It doesn't matter which style of
> comment.
>
> Is this bug fixed in version 8?
>
> --
> Replies send to this email address are automatically discarded. To
> reply, please post in this newsgroup.
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Tue May 25 1999 - 09:03:11 CDT

Original text of this message

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