Re: How to UnDefine a variable in SqlPlus?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 06 Jul 2005 11:15:23 +0200
Message-ID: <e78nc1dp1hvksvkje7chmls5vu2nkouut6@4ax.com>

On 4 Jul 2005 00:09:04 -0700, "William Robertson" <william.robertson_at_bigfoot.com> wrote:

>Ach C via DBMonster.com wrote:
>> Hi all,
>> I executed a script from sqlplus which included a && prameter.I executed
>> completely.Now I want to execute it for second time but it does not free that
>> && variable and do not ask for it from me.
>> I cleared buffer but no chance.What should I do to undefine this in the same
>> session?
>>
>> Note: I NEEDed that to be && in original scripts because of many times of
>> using it :)
>>
>
>UNDEFINE
To elaborate a little: put

UNDEFINE parameter

at the end of your script.

Jaap. Received on Wed Jul 06 2005 - 04:15:23 CDT