How To Clear Screen In Oracle 11g

8 Answers 8

To clear the SQL window you can use:

                clear screen;

which can also be shortened to

                cl scr;

Ben

49.2k 33 gold badges 118 silver badges 138 bronze badges

answered Feb 20 '13 at 11:49

RahulRahul

631 5 silver badges 3 bronze badges

Yes this doesn't answer the question, but it's the only place I've found that explains how to clear the SQL developer screen from inside a script. +1

Aug 30 '13 at 7:21
Can you create a function which clears the screen? So instead of typing clear screen, you could just say for example clear.

Jan 12 '18 at 15:17

If you're using sqlplus in a shell, like bash you can run the shell's clear command from sqlplus:

                SQL> host clear

you can abbreviate of course:

                SQL> ho clear

answered Aug 19 '10 at 1:22

DanaDana

1,038 8 silver badges 10 bronze badges

SQL>Clear Screen (It is used the Clear The Screen FUlly in SQL Plus Window)

answered Oct 24 '13 at 12:00

ShyamShyam

79 1 silver badge 1 bronze badge

Use cl scr on the Sql* command line tool to clear all the matter on the screen.

legoscia

38k 22 gold badges 104 silver badges 153 bronze badges

answered Jul 4 '14 at 12:48

Sunil GargSunil Garg

166 2 silver badges 7 bronze badges

Use the following command to clear screen in sqlplus.

              SQL > clear scr

answered Feb 15 '16 at 9:28

arunprakashpjarunprakashpj

3,336 2 gold badges 24 silver badges 31 bronze badges

answered Jul 23 '10 at 1:32

Jeffrey KempJeffrey Kemp

56.7k 13 gold badges 102 silver badges 148 bronze badges

Ctrl+Shift+D, but you have to put focus on the script output panel first...which you can do via the KB.

Run script.

              Alt+PgDn     -  puts you in Script Output panel. Ctrl+Shift+D -  clears panel. Alt+PgUp     -  puts you back in editor panel.

answered Dec 18 '14 at 17:56

thatjeffsmiththatjeffsmith

17.1k 3 gold badges 29 silver badges 96 bronze badges

In the Oracle SQL-plus:

                shift+del

answered Dec 18 '14 at 17:00

wrong command for use

Oct 18 at 19:06

Not the answer you're looking for? Browse other questions tagged oracle sqlplus oracle-sqldeveloper or ask your own question.