SQL*Plus Clear Screen Command

If you want to clear your screen in SQL*Plus, you can use the clear screen command:

 

SQL> select sysdate from dual

  2  /

 

SYSDATE

---------

31-JAN-12

 

SQL> clear screen

 

As soon as you press the Return key, you will end up with a SQL prompt at the top of an empty screen:

 

SQL>

The line above is intended to represent an empty screen with a SQL prompt at the top. Normally I would show a screen print in jpeg format at this point but this post is quite simple so I will leave you to try it yourself.

 

The command can be abbreviated to cl scr:

 

SQL> select count(*) from dba_users;

 

  COUNT(*)

----------

      1271

 

SQL> cl scr

 

... and again, you end up with a SQL prompt at the top of your display after you press Return:

 

SQL>