Re: clearing the screen

Hi

Write a C function that accesses the screen driver and sends the relevant commands to clear the screen then wrap this as an external procedure and call from PL/SQL...

you could of course you could just type "clear screen" in sqlplus first before running your pl/sql.

or from pl/sql change your loop to use dbms_output.put_line('.'); as you cannot print blanks with dbmsoutput.put_line()....

but as Daniel said, why???

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.