Re: PL/SQL escapes

From: Karl E. Jørgensen <kjorg_at_msn*DOT*com>
Date: 1998/01/16
Message-ID: <uXJM96sI9GA.179@upnetnews04>#1/1

Or:

SQL> set scan off

this will stop SQL*Plus from looking for '&'-characters

Hope this helps

--
Karl
Oracle Certified DBA

Wuits Manfred wrote in message <34BE7E55.5FE7_at_yumyum.at>...


>rsood wrote:

>>

>> What is the escape for an ampersand '&' in string literals in PL/SQL ?

>> So far, even if wrapped in quotes, the preprocessor interprets the token

>> after an ampersand as a variable name asks for its value.

>>

>> rsood_at_panix.com

>

>include following line in your code:

>

>set define off

Received on Fri Jan 16 1998 - 00:00:00 CST