Re: (Newbie) - how do I display output?

From: Haximus <e_at_t.me>
Date: Tue, 01 Mar 2005 21:20:51 GMT
Message-ID: <T05Vd.23471$TB.1152@edtnps84>

Paul wrote:

>
> stephan0h_at_gmx.net says...
>

>> SET SERVEROUTPUT ON does the trick.

>
>
> Also, how do I keep values between sessions? If I close down SQL Plus
> and then open it again, it keeps its old settings, not the ones I
> specified in the previous session! Any ideas? TIA.

SQL> STORE SET statefile REPLACE
SQL> (you session stuff)
SQL> @statefile

Basically, specify a file for state info, do whatever with your session, then invoke statefile to restore your session settings. Received on Tue Mar 01 2005 - 15:20:51 CST