add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, October 19

SQL DEVELOPER Shortcuts

Category
Command
Shortcut
Window
Activate Document 1
Alt-1
Window
Activate Document 2
Alt-2
Window
Activate Document 3
Alt-3
Window
Activate Document 4
Alt-4
Window
Activate Document 5
Alt-5
Window
Activate Document 6
Alt-6
Window
Activate Document 7
Alt-7
Window
Activate Document 8
Alt-8
Window
Activate Document 9
Alt-9
Versioning
Add Subversion Property...

Versioning
Add to Subversion...

Versioning
Add to svn:ignore...

Other
Advanced Format...
Ctrl-Shift-F7
Diagram
Align...

Window
Assign to Alt+1
Alt-Shift-1
Window
Assign to Alt+2
Alt-Shift-2
Window
Assign to Alt+3
Alt-Shift-3
Window
Assign to Alt+4
Alt-Shift-4
Window
Assign to Alt+5
Alt-Shift-5
Window
Assign to Alt+6
Alt-Shift-6
Window
Assign to Alt+7
Alt-Shift-7
Window
Assign to Alt+8
Alt-Shift-8
Window
Assign to Alt+9
Alt-Shift-9
Worksheet
Autotrace...
F6
Help
Back
Ctrl-Alt-Left
Navigate
Back
Alt-Left
Versioning
Branch/Tag...

View
Breakpoints
Ctrl-Shift-R
Diagram
Bring to Front

Navigate
Browse Symbol Doc...
Alt-Shift-Minus
Navigate
Browse Symbol...
Ctrl-Minus
Code Editor
Cancel
Escape
Versioning
Check Out from Subversion...

View
Classes

Versioning
Cleanup Working Copy

File
Clear Print Area

Other
Clear
Ctrl-D
Worksheet
Clear
Ctrl-D
File
Close All
Ctrl-Shift-F4
File
Close Others

File
Close
Ctrl-F4
File
Close
Ctrl-W
Source
Code Assist
Ctrl-Alt-Enter
Other
Code Template

Source
Collapse All
Ctrl-Shift-Open Bracket
Source
Collapse Doc

Source
Collapse Methods

Data Editor
Commit Changes
F11
Other
Commit Changes
F11
Versioning
Commit to Subversion...

Versioning
Commit Working Copy...

Worksheet
Commit
F11
Versioning
Compare Subversion properties

File
Compare With Each Other

File
Compare With File on Disk

Versioning
Compare with Latest Subversion Revision

File
Compare With Other File...

Versioning
Compare with Other Subversion Revision

Versioning
Compare with Previous Subversion Revision

Compare
Compare

PL/SQL Editor
Compile for Debug
Ctrl-Shift-F8
PL/SQL Editor
Compile
Ctrl-F8
Code Editor
Completion Insight
Ctrl-Space
View
Component Palette
Ctrl-Shift-P
View
Connections

Edit
Connect
Ctrl-D
Help
Context Help
Shift-F1
Help
Context Help
F1
Debug
Continue Step
Shift-F8
Code Editor
Convert Leading Spaces to Tabs
Ctrl-Shift-T
Code Editor
Convert Leading Tabs to Spaces
Ctrl-Shift-U
Code Editor
Convert Selection to Lowercase

Code Editor
Convert Selection to Uppercase

Other
Convert...

Edit
Copy Path
Ctrl-Shift-C
Versioning
Copy Subversion URL

Edit
Copy
Ctrl-C
Edit
Copy
Ctrl-Insert
Versioning
Create Subversion Repository...

History
Customize Filters...

Edit
Cut
Shift-Delete
Edit
Cut
Ctrl-X
View
Data

Other

Ctrl-N
Debug
Debug File

Other
Debug Implementation...
Shift-F9
Debug
Debug Project
Shift-F9
PL/SQL Editor
Debug
Ctrl-Shift-F10
Versioning
Delete Connection (Subversion)

Code Editor
Delete Current Line

Other
Delete Persisted Settings
Ctrl-Shift-G
Code Editor
Delete Previous Char
Backspace
Code Editor
Delete Previous Char
Shift-Backspace
Versioning
Delete Remote Resource...

Data Editor
Delete Selected Row(s)
Ctrl-D
Code Editor
Delete to Next Word Break

Code Editor
Delete to Next Word End

Code Editor
Delete to Next Word Start
Ctrl-T
Code Editor
Delete to Next Word Start
Ctrl-Delete
Code Editor
Delete to Previous Word Break

Code Editor
Delete to Previous Word End

Code Editor
Delete to Previous Word Start
Ctrl-Backspace
Code Editor
Delete Until End of Line
Ctrl-Shift-Y
Edit
Delete
Ctrl-Shift-D
Edit
Delete
Delete
Debug
Detach

Debug
Disable Breakpoint

Diagram
Distribute...

Code Editor
Duplicate Selection
Ctrl-Shift-D
Debug
Edit Breakpoint...

Versioning
Edit Connection... (Subversion)

Versioning
Edit Subversion Property...

Diagram
Edit
F2
Other
Edit
Ctrl-L
Code Editor
Emacs Append Next Kill

Code Editor
Emacs Backwards Kill Word

Code Editor
Emacs Capitalize Word

Code Editor
Emacs Delete Horizontal Space

Code Editor
Emacs Downcase Region

Code Editor
Emacs Downcase Word

Code Editor
Emacs End of File

Code Editor
Emacs Exchange Point and Mark

Code Editor
Emacs Kill Line

Code Editor
Emacs Kill Region

Code Editor
Emacs Kill Ring Save

Code Editor
Emacs Kill Word

Code Editor
Emacs Mark Buffer

Code Editor
Emacs Pop

Code Editor
Emacs Set Mark

Code Editor
Emacs Start of File

Code Editor
Emacs Upcase Region

Code Editor
Emacs Upcase Word

Code Editor
Emacs Yank

Debug
Enable Breakpoint

File
Exit
Alt-F4
Source
Expand All
Ctrl-Shift-Close Bracket
Source
Expand Doc

Source
Expand Methods

Worksheet
Explain Plan...
F10
Versioning
Export Connections... (Subversion)

Versioning
Export Files...

File
Export...

Edit
Extended Paste...
Ctrl-Shift-V
Tools
External Tools...

Window
File List
Alt-0
File
File On Disk

Data Editor
Filter Data
Ctrl-Alt-F
Debug
Find Execution Point

Search
Find Next Word at Cursor
Ctrl-F3
Search
Find Next
F3
Search
Find Previous Word at Cursor
Ctrl-Shift-F3
Search
Find Previous
Shift-F3
Search
Find...
Ctrl-F
Diagram
Fit to Window

Other
Format
Ctrl-F7
Help
Forward
Ctrl-Alt-Right
Navigate
Forward
Alt-Right
View
Freeze View
Ctrl-I
Other
Freeze View
Ctrl-Shift-P
Debug
Garbage Collect

Compare
Generate Patch...

Navigate
Go to Bookmark 0
Ctrl-0
Navigate
Go to Bookmark 1
Ctrl-1
Navigate
Go to Bookmark 2
Ctrl-2
Navigate
Go to Bookmark 3
Ctrl-3
Navigate
Go to Bookmark 4
Ctrl-4
Navigate
Go to Bookmark 5
Ctrl-5
Navigate
Go to Bookmark 6
Ctrl-6
Navigate
Go to Bookmark 7
Ctrl-7
Navigate
Go to Bookmark 8
Ctrl-8
Navigate
Go to Bookmark 9
Ctrl-9
Navigate
Go to Bookmark...
Ctrl-Shift-K
Compare
Go to First Difference

Compare
Go to Last Difference

Navigate
Go to Last Edit
Ctrl-Shift-Backspace
Navigate
Go to Line...
Ctrl-G
Navigate
Go to Next Bookmark
Ctrl-Q
Compare
Go to Next Difference

Navigate
Go to Next Message
Alt-F8
Navigate
Go to Previous Bookmark
Ctrl-Shift-Q
Compare
Go to Previous Difference

Navigate
Go to Previous Message
Alt-F7
Navigate
Go to Recent Files...
Ctrl-Equals
View
Heap

Code Editor
Highlight Matching Brace

Versioning
Import Connections... (Subversion)

Versioning
Import Files into Subversion Repository

File
Import...

Search
Incremental Find Backward
Ctrl-Shift-E
Search
Incremental Find Forward
Ctrl-E
Code Editor
Indent Block

Code Editor
Insert New Line
Enter
Code Editor
Insert New Line
Shift-Enter
Data Editor
Insert Row
Ctrl-I
Code Editor
Insert Tab
Tab
Debug
Inspect...
Ctrl-I
Code Editor
Join Line
Ctrl-J
Window
Left Editor
Alt-Page Up
Window
Left Tab
Shift-F5
Versioning
Lock in Subversion

View
Log
Ctrl-Shift-L
Tools
Lookup Oracle Error
Ctrl-Alt-Shift-E
Code Editor
Macro Playback

Code Editor
Macro Toggle Recording

View
Main

Versioning
Mark Resolved (Subversion)

Navigate
Maximize Toggle
Ctrl-Alt-M
Versioning
Merge (Subversion)...

Versioning
Merge Working Copy (Subversion)...

View
Monitors

Code Editor
Move Backward
Left
Code Editor
Move Down
Down
Code Editor
Move Forward
Right
Code Editor
Move Page Down
Page Down
Code Editor
Move Page Up
Page Up
Code Editor
Move to End of File
Ctrl-End
Code Editor
Move to End of Line
End
Code Editor
Move to Matching Brace
Alt-Close Bracket
Code Editor
Move to Matching Brace
Alt-Open Bracket
Code Editor
Move to Next Word Break

Code Editor
Move to Next Word End

Code Editor
Move to Next Word Start
Ctrl-Right
Code Editor
Move to Previous Word Break

Code Editor
Move to Previous Word End

Code Editor
Move to Previous Word Start
Ctrl-Left
Code Editor
Move to Start of File
Ctrl-Home
Code Editor
Move to Start of Line
Home
Code Editor
Move to Word End

Code Editor
Move to Word Start

Code Editor
Move Up
Up
Versioning
New Remote Directory...

Versioning
New Repository Connection (Subversion)...

View
New View

Other
New...
Ctrl-N
Window
Next File
Ctrl-Tab
Window
Next File
Ctrl-F6
Window
Next Pane
F6
Other
Next

Other
Open Declaration

Code Editor
Open Line

File
Open...
Ctrl-O
History
Open

File
Page Setup...

Code Editor
Parameter Insight
Ctrl-Shift-Space
Edit
Paste
Ctrl-V
Edit
Paste
Shift-Insert
Debug
Pause

Versioning
Pending Changes

Other
Popup Describe
Shift-F4
Other
Popup Menu
Shift-F10
Other
Popup Menu
Context Menu
Tools
Preferences...

Window
Previous File
Ctrl-Shift-F6
Window
Previous File
Ctrl-Shift-Tab
Window
Previous Pane
Shift-F6
Other
Previous

Other
Print File
Ctrl-P
File
Print...
Ctrl-P
File
Print...
Ctrl-P
Versioning
Properties (Versioning)

Versioning
Properties (Versioning)
Ctrl-Shift-O
Edit
Properties...

Versioning
Properties...

History
Properties

View
Property Inspector

View
Property Inspector
Ctrl-Shift-I
Diagram
Publish Diagram...

History
Purge Local History

Code Editor
Recenter Current Line

Edit
Redo
Ctrl-Y
Edit
Redo
Ctrl-Shift-Z
Edit
Redo
Alt-Shift-Backspace
Source
Reformat
Alt-Shift-F
Source
Reformat
Ctrl-Alt-L
View
Refresh
Ctrl-R
Other
Refresh
Ctrl-R
Navigate
Remove All Bookmarks

Navigate
Remove Bookmarks from File

Versioning
Remove from Subversion...

File
Rename...

Versioning
Replace with Base Subversion Revision

Search
Replace...
Ctrl-R
View
Reports

Versioning
Resolve Conflicts (Subversion)

History
Restore from Local History...

History
Restore from Revision

Debug
Resume
F9
Code Editor
Reverse Tab
Shift-Tab
Versioning
Revert (Subversion)...

Window
Right Editor
Alt-Page Down
Window
Right Tab
Alt-Shift-F5
Data Editor
Rollback Changes
F12
Other
Rollback Changes
F12
Worksheet
Rollback
F12
Other
Run File
Ctrl-F11
View
Run Manager

Run
Run Project
F11
Worksheet
Run Script
F5
Worksheet
Run Statement
Ctrl-Enter
Worksheet
Run Statement
F9
Other
Run Test
F9
Debug
Run to Cursor
F4
PL/SQL Editor
Run
Ctrl-F10
File
Save All

File
Save As...

Other
Save File
Ctrl-S
File
Save
Ctrl-S
File
Save
Ctrl-S
Code Editor
Scroll Line Down
Ctrl-Down
Code Editor
Scroll Line Up
Ctrl-Up
Code Editor
Scroll Page Down

Code Editor
Scroll Page Up

Help
Search

Edit
Select All
Ctrl-A
Code Editor
Select Line

Code Editor
Select Word

Code Editor
Selection Backward
Shift-Left
Code Editor
Selection Down
Shift-Down
Code Editor
Selection Forward
Shift-Right
Code Editor
Selection Page Down
Shift-Page Down
Code Editor
Selection Page Up
Shift-Page Up
Code Editor
Selection to End of File
Ctrl-Shift-End
Code Editor
Selection to End of Line
Shift-End
Code Editor
Selection to Matching Brace
Alt-Shift-Close Bracket
Code Editor
Selection to Matching Brace
Alt-Shift-Open Bracket
Code Editor
Selection to Next Word Break

Code Editor
Selection to Next Word End

Code Editor
Selection to Next Word Start
Ctrl-Shift-Right
Code Editor
Selection to Previous Word Break

Code Editor
Selection to Previous Word End

Code Editor
Selection to Previous Word Start
Ctrl-Shift-Left
Code Editor
Selection to Start of File
Ctrl-Shift-Home
Code Editor
Selection to Start of Line
Shift-Home
Code Editor
Selection to Word End

Code Editor
Selection to Word Start

Code Editor
Selection Up
Shift-Up
Diagram
Send to Back

Code Editor
Set Local Tab Size to 2
Ctrl-2
Code Editor
Set Local Tab Size to 4
Ctrl-4
Code Editor
Set Local Tab Size to 8
Ctrl-8
File
Set Print Area

Tools
Show Breadcrumbs

Window
Show Editor Menu
Alt-Minus
Tools
Show Selected Element Only

View
Show Status Bar

Tools
Show Whitespace
Ctrl-Shift-W
Code Editor
Smart Completion Insight
Ctrl-Alt-Space
View
Smart Data

Code Editor
Sort Selected Lines

Data Editor
Sort...
Ctrl-Alt-S
Other
SQL History: Append from Next
Ctrl-Shift-Down
Other
SQL History: Append from Previous
Ctrl-Shift-Up
Other
SQL History: Replace with Next
Ctrl-Down
Other
SQL History: Replace with Previous
Ctrl-Up
Worksheet
SQL History
F8
Worksheet
SQL Tuning Advisor...
Ctrl-F12
Worksheet
SQL Worksheet
Alt-F10
Other
SQL
Ctrl-Q
View
Stack

Help
Start Page

Debug
Step Into Bytecode

Debug
Step Into Method at Cursor

Debug
Step Into
F7
Debug
Step Out
Shift-F7
Debug
Step Over Bytecode

Debug
Step Over
F8
Debug
Step to End of Method

Diagram
Straighten Lines
Ctrl-L
Versioning
Subversion Navigator

Other
Surround With...

Versioning
Switch...

Help
Table of Contents

Debug
Terminate
Ctrl-F2
View
Threads

View
Thumbnail
Ctrl-Shift-T
Other
To Upper/Lower/Initcap
Ctrl-Quote
Navigate
Toggle Bookmark 0
Ctrl-Shift-0
Navigate
Toggle Bookmark 1
Ctrl-Shift-1
Navigate
Toggle Bookmark 2
Ctrl-Shift-2
Navigate
Toggle Bookmark 3
Ctrl-Shift-3
Navigate
Toggle Bookmark 4
Ctrl-Shift-4
Navigate
Toggle Bookmark 5
Ctrl-Shift-5
Navigate
Toggle Bookmark 6
Ctrl-Shift-6
Navigate
Toggle Bookmark 7
Ctrl-Shift-7
Navigate
Toggle Bookmark 8
Ctrl-Shift-8
Navigate
Toggle Bookmark 9
Ctrl-Shift-9
Navigate
Toggle Bookmark
Ctrl-K
Debug
Toggle Breakpoint
F5
Code Editor
Toggle Insert Mode
Insert
Code Editor
Toggle Line Comments
Ctrl-Slash
Code Editor
Toggle Line Comments
Ctrl-Shift-Slash
Code Editor
Transpose Chars

Code Editor
Trim Trailing Whitespace

Edit
Undo
Ctrl-Z
Edit
Undo
Alt-Backspace
Code Editor
Unindent Block

Versioning
Unlock in Subversion

Code Editor
Unselect
Ctrl-Back Slash
Worksheet
Unshared SQL Worksheet
Ctrl-Shift-N
Versioning
Update from Subversion...

Versioning
Update Working Copy...

Versioning
Version Application...

Versioning
View Subversion Properties

Diagram
Visual Properties...

Debug
Watch...
Ctrl-F5
View
Watches

Window
Windows...

Diagram
Zoom 10%

Diagram
Zoom 100%

Diagram
Zoom 125%

Diagram
Zoom 15%

Diagram
Zoom 150%

Diagram
Zoom 200%

Diagram
Zoom 25%

Diagram
Zoom 40%

Diagram
Zoom 400%

Diagram
Zoom 5%

Diagram
Zoom 50%

Diagram
Zoom 75%

Diagram
Zoom In
Ctrl-NumPad +
Diagram
Zoom Out
Ctrl-NumPad -
Diagram
Zoom to Selected


No comments: