29

With the aim of reducing mouse activity I was wondering if there was such a command shortcut (eg cls or Ctrl + L) to provide the SQL * Plus (?) "CLEAR SCREEN" command functionality found by clicking the rubber-on-end- of-pencil icon in Oracle SQL Developer to clear the lower "Results" sub-tab (... incorrect terminology I'm sure).

Nicolás Alarcón Rapela
  • 2,714
  • 1
  • 18
  • 29
MarkyBoyMark
  • 361
  • 1
  • 3
  • 7
  • 1
    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. – thatjeffsmith Dec 18 '14 at 17:55
  • http://docs.oracle.com/database/121/SQPUG/ch_twelve012.htm#SQPUG033 –  Nov 10 '16 at 07:14

8 Answers8

69

To clear the SQL window you can use:

clear screen;

which can also be shortened to

cl scr;
Ben
  • 51,770
  • 36
  • 127
  • 149
Rahul
  • 691
  • 5
  • 3
  • 1
    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 – Dexter Aug 30 '13 at 07:21
  • Can you create a function which clears the screen? So instead of typing clear screen, you could just say for example clear. – hadyfarhat Jan 12 '18 at 15:17
9

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
Dana
  • 1,048
  • 8
  • 10
7

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

Shyam
  • 79
  • 1
  • 1
7

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

legoscia
  • 39,593
  • 22
  • 116
  • 167
Sunil Garg
  • 484
  • 5
  • 9
6

Use the following command to clear screen in sqlplus. 

SQL > clear scr
codeX
  • 4,842
  • 2
  • 31
  • 36
4

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.
thatjeffsmith
  • 20,522
  • 6
  • 37
  • 120
4

CTRL+D? http://www.scribd.com/doc/7580088/SQL-Developer-Hot-Keys

If that doesn't work, you might be able to set up an Accelerator: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b31695/intro.htm#sthref208

Jeffrey Kemp
  • 59,135
  • 14
  • 106
  • 158
-2

In the Oracle SQL-plus:

shift+del
user4375171
  • 1