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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758198434, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/Software/Oracle-SQL-Developer/GUI/SQL-Worksheet/index(109): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78