Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OCI: How can I insert a string including an amphersand (&) from OCI??
"Finn Ellebaek Nielsen" <_remove_fen_remove__at_changegroup.dk> writes:
> Hi Ole.
>
> Well, in SQL*Plus, & and the following identifer will be interpreted as a
> variable, hence SQL*Plus asks for the value. You can avoid that by doing a
> "set scan off" in SQL*Plus.
Use SET DEFINE. The SET SCAN command has been obsolete for many years. Although there are no plans to remove SCAN there is no doubt that DEFINE will eventually outlive it.
Chris
-- Christopher Jones, Oracle Corporation, Australia.Received on Thu Oct 17 2002 - 20:50:31 CDT