SQL*Plus (MOSC)

MOSC Banner

Is there a way to reset a SET variable to the previous value?

edited Feb 2, 2010 12:43AM in SQL*Plus (MOSC) 10 commentsAnswered
Hi all,
I have different script files starting a common script file. The common one should "SET PAUSE OFF", show the result of a SELECT statement and set pause back to the previous value, because I don't know, which are the preferences of the calling script.

Is there a way to do that? Best would be a way working with all kind of SET variables...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center