Home » RDBMS Server » Server Utilities » variables in sqlplus
variables in sqlplus [message #69725] Tue, 26 February 2002 07:33 Go to next message
Jessica
Messages: 3
Registered: March 2000
Junior Member
I want to run a script that uses a variable several times ... therefore I use the && on the first instance of the variable. Is there anyway I can then "turn off" its reference to what I entered (without logging out)? I want to be able to rerun the script and enter a different value for the variable to be used through the script that time. Any suggestions?? Thanks!

Report message to a moderator

Re: variables in sqlplus [message #69740 is a reply to message #69725] Thu, 28 February 2002 04:10 Go to previous messageGo to next message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Try using single ampersand "&" instead of two.

Regards,

Vikas.
vicky@icenet.net

Report message to a moderator

Re: variables in sqlplus [message #70361 is a reply to message #69725] Mon, 03 June 2002 08:33 Go to previous message
Bob
Messages: 49
Registered: March 1999
Member
use the following at the end of your script:

undefine <variable name>

Report message to a moderator

Previous Topic: Oracle 8.1.7 Export/Import Authentication Error
Next Topic: regarding merging of tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 11:53:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.