Re: save sqlplus conf in a variable

> >
> > 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.
> >
> I'd say there's some miscommunication here...
> The OP just wants to remember a variable value in a SQL*Plus
> (assumption) script. Lookup 'new value' in the SQL*Plus guide, if that's
> what you are using.
>
> 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 Bortel

Thanks for the response.
I did not know that setting it on again will give me back the original value.
My problem is that I do not know even if define is set or not set. I just want to set it off for my script and then restore the original state at the end of my script.

Thanks,
Sunil. Received on Thu Jan 08 2004 - 23:33:25 CST