Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: &variables : problem with setting them back
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
![]() |
![]() |