Search notes:

Oracle SQL Developer: SQL Worksheet

The SQL Worksheet is the place where SQL, PL/SQL and SQL*Plus statements can be entered and executed in Oracle SQL Developer.
The keyboard shortcut ctrl+shift+n creates an unshared worksheet for a connection.

Opening a new worksheet

On the Menu: Tools -> SQL Worksheet
Keyboard shortcut Alt+F10
… ?

Quickly navigate to a numbered Worksheet

SQL Worksheets can be assigned a number by clicking its tab and the pressing alt+shift+number (or Window->Assign File Accelerator). The number will then be shown as a small superscript in the tab.
After having assigned a number, the numbered tab can be quickly navigated to with alt+number.

Formatting trace files

The Worksheet automatically formats a trace file if it is dragged onto it.
Alternatively, a trace file can also be «imported» with File -> Open

Snippets

The menu View -> Snippets allows to define «snippets» (text fragments) that can be dragged onto the SQL Worksheet.

Right-click / Context Menu

Run Statement F9
Run Script F5
Create Report…
Save as Snippet…
Explain…
Autotrace… F6
SQL Tuning Advisor… Ctrl+F12
Commit F11
Rollback F12
Clear Ctrl+d
SQL History F8
To Upper/Lower/InitCap Alt+Quote
Cut Ctrl+x
Copy Ctrl+c
Paste Ctrl+v
Select All Ctrl+a
Debug Ctrl+Shift+F10
Toggle Line Comments Ctrl+slash
Completion Insight Ctrl+space
Indent Block
Unindent Block
Refactoring ->
Code Outline Apparently required to open the Arbori Editor (see for example here).
Format Ctrl+F7
Embed/Expose… Ctrl+Shift+F7
Open Declaration
Popup Describe Shift+F4
Code Template

See also

Tools -> Preferences -> Database -> SQL Editor Code Templates
The menu View -> Show Only Editor

Index