Friday, May 9, 2014

Useful SQL Developer Shortcuts

A short list of some useful shortcuts of SQL Developer.


Key
Description
Ctrl+Alt+R
Check for updated data
Ctrl+Alt+W
Toggle focus between popup and primary window
Ctrl+/
Toggles line commenting
Ctrl+Alt+0. . .Ctrl+Alt+5
Switch diagram layout
Ctrl+5
Strikethrough
Ctrl+A
Select all
Ctrl+B
Boldface
Ctrl+Alt+C
Toggle source code editing
Ctrl+E
Center alignment
Ctrl+H
Create hyperlink
Ctrl+Shift+H
Remove hyperlink
Ctrl+I
Italics
Ctrl+L
Full justified alignment
Ctrl+Shift+L
Left alignment
Ctrl+Alt+L
Numbered list
Ctrl+M
Increase indentation
Ctrl+Shift+M
Decrease indentation
Ctrl+Alt+M
Launch context menu
Ctrl+R
Right alignment
Ctrl+Alt+R
Toggle rich text editing
Ctrl+Shift+S
Clear text styles
Ctrl+U
Underline
Ctrl+Y
Redo
Ctrl+Z
Undo
Ctrl+Shift+^
Go up one level
Ctrl+N
New file will be open.
Ctrl+O
Opens the existing file.
Alt+V+C
Opens the connections window.
Alt+F10
Select connection and open new worksheet.
Ctrl+Shift+D
Duplicate the line
Ctrl+'(Single Quote)
Toggle the case (Upper/Lower/Initcap)
Ctrl+ Enter
Executes the current statement
Ctrl+ Space
Invokes code insight on demand
Ctrl-Up/Dn               
Replaces worksheet with previous/next SQL from SQL History
Shift+F4               
Opens a Describe window for current object at cursor
Ctrl+F7    
Format SQL
Ctrl+ Space
Executes the current statement

As a developer I used Bold ones the most. They are my favorite.

No comments:

Post a Comment