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: PL/SQL escapes

Re: PL/SQL escapes

From: Glenn Ferguson <glenn_at_corp.home.net>
Date: 1998/01/12
Message-ID: <34BA52F0.F65F06B4@corp.home.net>#1/1

Try chr(038) or you can "set scan off" in order not to get prompted for a value.

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
  Received on Mon Jan 12 1998 - 00:00:00 CST

Original text of this message

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