SQLDev KB Shortcuts OS X Cheat Sheet

A Programming › SQL cheat sheet in English by thatjeffsmith

shortcut keys for oracle sql developer, on a mac

22,824 views 3,881 downloads 10 Nov 2015 History

PRs

3.7 avg · 0 ratings

SQL Worksheet

Execute Query	Control + Enter or fn*+ F9
Execute Script	F5
Explain Plan	F10
Autotrace	F6
SQL Recall	cmd + Up/Down
Recall Recall Append	cmd + Shift + Up/Down
SQL History	F8
Completion Insight	Ctrl + Spacebar
Toggle Comment	cmd + option + /
Toggle Case	Ctrl + '
Switch to Results	fn + cmd + down
Switch to Editor	fn + cmd + up
Open Unshared Worksheet	cmd + shift + N
DESC	ctrl + F12

All function keys on Mac might require keying the 'fn' button first. Otherwise, enable "Use all F1, F2, etc. keys as standard function keys" in your keyboard preferences.

You can also go into the Preferences and define the shortcut keys to any sequence, and export, import, and share these preferences with other users.

SQLcl

Run buffer immediately	Ctrl + R
Go to top of buffer	Ctrl + W
Go to bottom of buffer	Ctrl + S
Go to start of line	Ctrl + A
Go to end of line	Ctrl + E
Recall Previous SQL	Up or Down
File/SQL Completion	Tab
Clear Screen	Ctrl + L

Developed with OS X 10.11

Badges

Nice Cheat Sheet Good Cheat Sheet

Comments

No comments yet.