|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 4th, 2005, 01:52 AM
|
|||
|
|||
How to UnDefine a variable in SqlPlus?
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 
|
|
#2
July 4th, 2005, 02:25 AM
|
|||
|
|||
|
Quote from the manual
Defined variables retain their values until one of the following events occurs: * you enter a new DEFINE command referencing the variable * you enter an UNDEFINE command referencing the variable Details for the DEFINE command: http://download-west.oracle.com/doc...h13.htm#1008884 Details for the UNDEFINE command: http://download-west.oracle.com/doc...h13.htm#1014278
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > How to UnDefine a variable in SqlPlus? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
