Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

CLEAR SCREEN - Oracle SQL Developer shortcut?

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).

like image 260
MarkyBoyMark Avatar asked Jun 24 '10 10:06

MarkyBoyMark


People also ask

How do I clear the screen in SQL Developer?

The Clear command clears the screen of the SQL*Plus application window and the screen buffer. Shift+Del is the keyboard shortcut for the Clear command.

Which is an SQL Plus command?

SQL*Plus is a command-line tool that provides access to the Oracle RDBMS. SQL*Plus enables you to: Enter SQL*Plus commands to configure the SQL*Plus environment. Startup and shutdown an Oracle database.


4 Answers

To clear the SQL window you can use:

clear screen;

which can also be shortened to

cl scr;
like image 92
Rahul Avatar answered Oct 21 '22 17:10

Rahul


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
like image 38
Dana Avatar answered Oct 21 '22 17:10

Dana


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

like image 40
Shyam Avatar answered Oct 21 '22 17:10

Shyam


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

like image 7
Sunil Garg Avatar answered Oct 21 '22 15:10

Sunil Garg