Re: clearing the screen

From: Richard Kuhler <noone_at_nowhere.com>
Date: Sat, 04 Oct 2003 17:57:35 GMT
Message-ID: <jSDfb.43145$5z.35351@twister.socal.rr.com>

Rene Nyffenegger wrote:
>>Can someone tell me how to clear the screen using pl/sql.
>>I have tried the following but to no avail.
>>
>>begin
>>
>>for v_counter in 1..30 loop
>>dbms_output.put_line(' ');
>>end loop;
>>end;

> 
> Type 
>    SET SERVEROUTPUT ON FORMAT WRAPPED
> prior to running the loop. That should do the trick.

Interesting. Only the default WORD_WRAPPED causes the trim I mentioned to occur. The other options WRAPPED and TRUNACTED don't trim and hence don't suppress blank output (or leading spaces). Learn something everyday I guess.

Richard Kuhler Received on Sat Oct 04 2003 - 12:57:35 CDT