Re: clearing the screen

From: Richard Kuhler <noone_at_nowhere.com>
Date: Sat, 04 Oct 2003 01:11:53 GMT
Message-ID: <t7pfb.29113$T46.13204@twister.socal.rr.com>

Odba1961 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;

PUT_LINE does a trim and won't output anything if the result is null. You can force an output by using a non-space character.

dbms_output.put_line(chr(0));

Although, it sounds like you're trying to write an application using SQL*Plus which I'd recommend against. Why exactly do you need this?

Richard Kuhler Received on Fri Oct 03 2003 - 20:11:53 CDT