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

Home -> Community -> Usenet -> c.d.o.misc -> How to escape the ampersand in a string.

How to escape the ampersand in a string.

From: Björn-Åke Segrell <pinne_at_pegit.se>
Date: Sun, 05 Dec 1999 16:53:20 +0100
Message-ID: <384A8A70.514911A6@pegit.se>


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 Sun Dec 05 1999 - 09:53:20 CST

Original text of this message

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