Sunil wrote:
>>you can save
>>ALL of your sqlplus settings to a sql script file and then reset them at a
>>later point. There is an example of this (and a lot more useful stuff
>>besides) at www.ixora.com.au/scripts (you will find the sqlplus settings
>>ones under prerequisites).
>
>
> Is it possible to save a particular value in a sqlplus variable and later
> set it back to the original value.
>
> I need to do something like this. I am adding a call to new sql script to a
> huge sql script which has calls to other sql scripts. I need to do "set
> define off" in my script but I need to set the value of define to what was
> there originally at the end of my script. The solution at
> www.ixora.com.au/scripts will work for me. But I am interested in knowing if
> there is any easier way as I am interested in only the "define" value
>
> Thanks,
> Sunil.
No. From the sounds of what you are writing you shouldn't be writing
scripts but rather procedures. If you want to store values ... store
them in a table and query them back into memory when the proc is run.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Jan 08 2004 - 10:39:47 CST
