Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to escape the ampersand in a string.
SET DEFINE OFF, then you can use it!
"Björn-Åke Segrell" wrote:
>
> Hi,
>
> How the he.. do I escape the &-sign (ampersand) in a VARCHAR2 host
> variable
> in PL/SQL ?
> I've tried '&&', '\&', '/&', etc and searched the doc and the net as
> crazy. But i just can't find it.
>
> If someone knows the answer or where I can find it + maybe have some
> good FAQ-links
> for Oracle development (for this must surely be one).
>
> /Cheers
Received on Mon Dec 06 1999 - 03:59:22 CST