Re: Escaping & symbol in SQLPlus

From: <uytterhoeven_at_my-dejanews.com>
Date: Mon, 03 May 1999 13:52:06 GMT
Message-ID: <7gk9m5$u42$1@nnrp1.dejanews.com>

In article <Pine.A41.3.95.990503134136.13460A-100000_at_aix5.kbar.dtu.dk>, Morten <c960901_at_aix5.kbar.dtu.dk> wrote:
>
> Can any of you tell me how to do that? If I do an insert
> or update which contains & I'm prompted for a value of
> the text that follows the &... Hmm..
>
> Thanks in advance
>
> Morten
>
>

Hi,

you should set a system variable called ESCAPE.

SET ESC[APE] {\|c|OFF|ON}

Defines the character you enter as the escape character. OFF undefines the escape character. ON enables the escape character. ON changes the value of c back to the default "\". You can use the escape character before the substitution character (set through SET DEFINE) to indicate that SQL*Plus should treat the substitution character as an ordinary character rather than as a request for variable substitution.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon May 03 1999 - 08:52:06 CDT