Shortcuts in real life may not always lead to success, but when it comes to SQL Developer, utilizing shortcuts is a surefire way to impress your boss, friends, and colleagues. These shortcuts enhance the use of graphical tools and simplify database development, making tasks faster and easier. Mastering Oracle SQL Developer shortcuts will save you time and significantly boost productivity.
With these shortcuts, you can accelerate SQL coding, efficiently manage data, and automate routine administrative tasks. The Oracle SQL Developer shortcuts listed below are ones I frequently use, and I highly recommend incorporating them into your workflow if you haven’t already. Download the Oracle SQL Developer shortcuts list in PDF format and take your efficiency to the next level.
Most Used Oracle SQL Developer Shortcuts Action Oracle SQL Developer Shortcuts Open Ctrl + O Print Ctrl + P Save Ctrl + S Close Ctrl + F4 Close All Ctrl + Shift + F4 Copy Ctrl + C Paste Ctrl + V Cut Ctrl + X Copy Path Ctrl + Shift + C Paste Path Ctrl + Shift + V Cut Path Ctrl + Shift + X Undo Ctrl + Z Redo Ctrl + Y Select All Ctrl + A Add Cursor Above Alt + Shift + Page Up key Add Cursor Below Alt + Shift + Page Down key
Code Editor Shortcuts Action Oracle SQL Developer shortcuts Completion Insight Ctrl + Spacebar Duplicate the Line Ctrl + Shift + D Delete Line Alt + Shift + D Cancel Esc Delete the Previous character Backspace Delete Next character Shift + Backspace Delete to start of the Next word Ctrl + Delete Delete to start of the Previous word Ctrl + Backspace Delete to end of line Ctrl + Shift + Y Jump to the beginning of the line Home Jump to the end of the line End Join Line Ctrl + J Move line or selection up Ctrl + Shift + Up Arrow key Move the line or selection down Ctrl + Shift + Down Arrow key Jump to the Next word Ctrl + Right Arrow key Jump to the Previous word Ctrl + Left Arrow key Scroll line down Ctrl + Down Arrow key Scroll line up Ctrl + Up Arrow key Expand selection left Shift + Left Arrow key Expand selection right Shift + Right Arrow key Expand selection up Shift + Up Arrow key Expand selection down Shift + Down Arrow key Expand the selection to the beginning of the line Shift + Home Expand selection to end of line Shift + End Expand selection to closing matching brace Alt + Shift + ] Expand selection to opening matching brace Alt + Shift + [ Expand selection to the Next word Ctrl + Shift + Right Arrow key Expand the selection to the Previous word Ctrl + Shift + Left Arrow key Set the Local tab to size 2 Ctrl + 2 Set the Local tab to size 4 Ctrl + 4 Set the Local tab to size 8 Ctrl + 8 Toggle Line Comment Ctrl + /
Data Editor Shortcuts Action Oracle SQL Developer shortcuts Left Left Arrow key Right Right Arrow key Up Up Arrow key Down Down Arrow key Cell Popup Alt + Enter Commit Changes F11 Delete selected rows Ctrl + D Filter data Ctrl + Alt + F Insert row Ctrl + I Refresh Ctrl + R Rollback changes F12 Sort Ctrl + Alt + S
Debug Shortcuts Action Oracle SQL Developer shortcuts Continue Step Shift + F8 Find Execution Point Alt + F3 Inspect Ctrl + I Resume F9 Run to Cursor F4 Step Into F7 Step Out Shift + F7 Step Over F8 Terminate Ctrl + F2 Toggle Breakpoint F5 Watch Ctrl + F5
Metrics Shortcuts Action Oracle SQL Developer shortcuts Actual Size Shift + Home Save Image Ctrl + S Pan (drag) up Up Arrow key Pan (drag) down Down Arrow key Pan (drag) left Left Arrow key Pan (drag) right Right Arrow key Zoom in Ctrl + Right Arrow key Zoom out Ctrl + Left Arrow key Zoom to Fit Ctrl + Home
Navigate Shortcuts Action Oracle SQL Developer shortcuts Backward Alt + Left Arrow key Forward Alt + Right Arrow key Toggle Bookmark 0…9 Ctrl + Shift + 0…9 Go to Bookmark 0…9 Ctrl + 0…9 Go to the last Edit Ctrl + Shift + Backspace Goto Line Ctrl + G Go to the Next Bookmark Ctrl + Q Go to Previous Bookmark Ctrl + Shift + Q Go to Next Member Alt + Down Arrow key Go to Previous Member Alt + Up Arrow key Go to Next Message Alt + F8 Go to Previous Message Alt + F7 Go to Recent Files Ctrl + = Maximize Toggle Ctrl + Alt + M Navigate down Ctrl + ‘ Navigate up Ctrl + Shift + ‘
Source Shortcuts Action Oracle SQL Developer shortcuts Code Assist Ctrl + Alt + Enter Collapse All Ctrl + Shift + [ Expand All Ctrl + Shift + ] Collapse Block Ctrl + [ Expand Block Ctrl + ] Complete Statement Ctrl + Shift + Enter Expand Selection Ctrl + Shift + = Narrow Selection Ctrl + Shift + – Focus Breadcrumbs Ctrl + Shift + . Quick Doc Ctrl + D Reformat Alt + Shift + F Show Whitespace Ctrl + Shift + W
Worksheet Shortcuts Action Oracle SQL Developer shortcuts Autotrace F6 Clear Ctrl + D Commit F11 Explain Plan F10 Rollback F12 Run Script F5 Run Statement Ctrl + Enter SQL History F8 SQL Tuning Advisor Ctrl + F12 SQL Worksheet Alt + F10 Times Ten Index Advisor Ctrl + Shift + X Unshared SQL Worksheet Ctrl + Shift + N Toggle Case Ctrl + ‘
Window Shortcuts Action Oracle SQL Developer shortcuts Activate Document 1…9 Alt + 1…9 Assign to Alt + 1…9 Alt + Shift + 1…9 File List Alt + 0 Left Editor Alt + Page Up key Right Editor Alt + Page Down key Next Pane F6 Previous Pane Shift + F6 Next File Ctrl + Tab Previous File Ctrl + Shift + Tab Left Tab Shift + F5 Right Tab Alt + Shift + F5 Show Editor Menu Alt + –
View Shortcuts Action Oracle SQL Developer shortcuts Breakpoints Ctrl + Shift + R Components Ctrl + Shift + P Freeze Content Ctrl + I Log Ctrl + Shift + L Refresh Ctrl + R
Search Shortcuts Action Oracle SQL Developer shortcuts Find Ctrl + F Find Next F3 Find Previous Shift + F3 Find the Next Word at the Cursor Ctrl + F3 Find the Previous Word at the Cursor Ctrl + Shift + F3 Incremental Find Forward Ctrl + E Incremental Find Backward Ctrl + Shift + E Global Search ` Replace Ctrl + R
Other Shortcuts Action Oracle SQL Developer shortcut keys Embed or Expose Ctrl + Shift + F7 Format Ctrl + F7 Popup Descrip Shift + F4 Context Menu Shift + F10 Properties Ctrl + Shift + I Quick Action Ctrl + Alt + A SQL History – append from Next Ctrl + Shift + Down Arrow key SQL History – append from Previous Ctrl + Shift + Up Arrow key SQL History – replace with Next Ctrl + Down Arrow key SQL History – replace with Previous Ctrl + Up Arrow key Run File Ctrl + F11 Build or Make Ctrl + Shift + F9 Build or Rebuild Alt + Shift + F9 Context Help F1 Help Backward Ctrl + Alt + Left Arrow key Help Forward Ctrl + Alt + Right Arrow key Compile Ctrl + F8 Compile for Debug Ctrl + Shift + F8 Debug Ctrl + Shift + F10 Run Ctrl + F10 Open Connections Alt + V + C Select the connection and open a new worksheet Alt + F10
Oracle SQL Developer is a reliable solution for Oracle database management, but it’s essential to consider other options that could offer additional benefits. DBeaver is often regarded as a comparable alternative or competitor to Oracle SQL Developer. Take a look at the DBeaver Shortcuts list to explore its features.
READ NEXT:
