Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL escapes
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