Re: How to escape the ampersand in a string.

From: Marc Parkinson <marcpark_at_uswest.net>
Date: Wed, 08 Dec 1999 21:30:03 -0700
Message-ID: <384F304B.471BE344@uswest.net>

You may want to try another approach. Set define to something else. That way the & character will not
be treated as a wild card.

Marc Parkinson

"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 Wed Dec 08 1999 - 22:30:03 CST