Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> save sqlplus conf in a variable

save sqlplus conf in a variable

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Thu, 8 Jan 2004 16:29:38 +0530
Message-ID: <NVaLb.6$lo4.79@news.oracle.com>


> 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 Thu Jan 08 2004 - 04:59:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US