Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: save sqlplus conf in a variable
Daniel Morgan wrote:
> Sunil wrote: >>>> besides) at www.ixora.com.au/scripts (you will find the sqlplus settings
>>> 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
> > > 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. >
But you don't need it - set define off will just disable it, not change the value. Set it on again, and it has the original value again. And... it is session dependent. Exit at the end of your script, and you're done. Any new session will have the default value.
-- Regards, Frank van BortelReceived on Thu Jan 08 2004 - 15:44:59 CST