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

Home -> Community -> Usenet -> c.d.o.misc -> Re: clearing the screen

Re: clearing the screen

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 4 Oct 2003 09:19:51 GMT
Message-ID: <blm3bn$e2idt$1@ID-82536.news.uni-berlin.de>

> 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.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch
Received on Sat Oct 04 2003 - 04:19:51 CDT

Original text of this message

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