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  /
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:

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;
SQL> cl scr
... and again, you end up with a SQL prompt at the top of your display after you press Return:

No comments: