Re: how to keep configuration in sql*plus ?

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3ff92630$0$13343$ed9e5944_at_reading.news.pipex.net...
> In addition to Ana and Hans' comments you may wish to note that 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. Received on Mon Jan 05 2004 - 04:14:57 CST