Wednesday, February 15, 2012

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>

No comments: