Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: &variables : problem with setting them back

Re: &variables : problem with setting them back

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/02/16
Message-ID: <950725769.23504.0.pluto.d4ee154e@news.demon.nl>#1/1

use undefine <variable_name> (without &) Hth,

Sybrand Bakker, Oracle DBA

Lars Frik <lars_at_shian.de> wrote in message news:88embm$fb7_at_poseidon.rz.uni-duesseldorf.de...
> hi,
>
> as a beginner in programming oracle system, i tried to get a &variable and
> work on with the value of it. when i start my script again, the &variable
> still
> has its old value and so no new value can be inserted.
> it only works when i leave the sql*plus prompt with exit and reconnect to
 it
> ...
> but i think that isn't the right way ;o)
> so how could you reset the &variables that you insert with one command ,
> when you start the script again ?
>
> thanks for the tips,
> greetings
>
> lars
>
> lars_at_shian.de
> germany
>
>
Received on Wed Feb 16 2000 - 00:00:00 CST

Original text of this message

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