Oracle SQL Developer 4 (Windows)

Worksheet

SQL Tuning Advisor

Ctrl + F12

All hotkeys for Oracle SQL Developer 4 (Windows)

Code Editor
Right/ left/ up/ down

Arrow Keys

Code Editor
Cancel

Esc

Code Editor
Completion Insight

Ctrl + Space

Code Editor
Duplicate the Line

Ctrl + Shift + D

Code Editor
Delete Line

Alt + Shift + D

Code Editor
Delete Previous / Next character

Backspace / Shift + Backspace

Code Editor
Delete to start of Next word

Ctrl + Delete

Code Editor
Delete to start of Previous word

Ctrl + Backspace

Code Editor
Delete to end of line

Ctrl + Shift + Y

Code Editor
Jump to beginning of line/ end of line

Home / End

Code Editor
Join Line

Ctrl + J

Code Editor
Move line or selection up/ down

Ctrl + Shift + Arrow Up / Arrow Down

Code Editor
Jump to Next/ Previous word

Ctrl + Arrow Right / Arrow Left

Code Editor
Scroll line down/ up

Ctrl + Arrow Down / Arrow Up

Code Editor
Expand selection left/ right/ up/ down

Shift + Arrow Keys

Code Editor
Expand selection to beginning/ end of line

Shift + Home / End

Code Editor
Expand selection to beginning/ end of file

Ctrl + Shift + Home / End

Code Editor
Expand selection to closing matching brace

Alt + Shift +Close Brackets

Code Editor
Expand selection to opening matching brace

Alt + Shift +Open Brackets

Code Editor
Expand selection to Next/ Previous word

Ctrl + Shift + Right Arrow / Left Arrow

Code Editor
Set Local tab to size 2/ 4/ 8

Ctrl + 2 / 4 / 8

Code Editor
Toggle Line Comment

Ctrl + /

Data Editor
Left/ right/ up/ down

Arrow Keys

Data Editor
Cell Popup

Alt + Enter

Data Editor
Commit Changes

F11

Data Editor
Delete selected row(s)

Ctrl + D

Data Editor
Filter data

Ctrl + Alt + F

Data Editor
Insert row

Ctrl + I

Data Editor
Refresh

Ctrl + R

Data Editor
Rollback changes

F12

Data Editor
Sort

Ctrl + Alt + S

DBMS Output
Clear/ Delete

Ctrl + D

DBMS Output
New

Ctrl + N

DBMS Output
Print

Ctrl + P

DBMS Output
Save

Ctrl + S

Debug
Continue Step

Shift + F8

Debug
Find Execution Point

Alt + F3

Debug
Inspect

Ctrl + I

Debug
Resume

F9

Debug
Run to Cursor

F4

Debug
Step Into/ Step Out

F7 / Shift + F7

Debug
Step Over

F8

Debug
Terminate

Ctrl + F2

Debug
Toggle Breakpoint

F5

Debug
Watch

Ctrl + F5

Edit
Add Cursor Above/ Below

Alt + Shift + Page Up / Page Down

Edit
Cut/ Copy/ Paste

Ctrl + X / Ctrl + C / Ctrl + V

Edit
Cut/ Copy/ Paste Path

Ctrl + Shift + X / Ctrl + Shift + C / Ctrl + Shift + V

Edit
Undo/ Redo

Ctrl + Z / Ctrl + Y

Edit
Select All

Ctrl + A

File
Open

Ctrl + O

File
Print

Ctrl + P

File
Save

Ctrl + Shift + F4

File
Close

Ctrl + F4

File
Close All

Ctrl + Shift + F4

Metrics
Actual Size

Shift + Home

Metrics
Save Image

Ctrl + S

Metrics
Pan (drag) up/down/left/ right

Arrow Keys

Metrics
Zoom in

Ctrl + Arrow Right / Ctrl +Drag Right

Metrics
Zoom out

Ctrl + Arrow Left / Ctrl +Drag Left

Metrics
Zoom to Fit

Ctrl + Home

Navigate
Backwards/ Forwards

Alt + Arrow Left / Arrow Right

Navigate
Bookmarks

Open Bookmarks

Navigate
Toggle Bookmark 0…9

Ctrl + Shift + 09

Navigate
Go to Bookmark 0…9

Ctrl + 09

Navigate
Go to last Edit

Ctrl + Shift + Backspace

Navigate
Goto Line

Ctrl + G

Navigate
Go to Next/ Previous Bookmark

Ctrl + Q / Ctrl + Shift + Q

Navigate
Go to Next/ Previous Member

Alt + Arrow Down / Arrow Up

Navigate
Go to Next/ Previous Message

Alt + F8 / F7

Navigate
Go to Recent Files

Ctrl + =

Navigate
Maximize Toggle

Ctrl + Alt + M

Navigate
Navigate down/ up

Ctrl + ' / Ctrl + Shift + '

Connections
Open Connections

Alt + V + C

Connections
Select connection and open new worksheet.

Alt + F10

PL/SQL Editor
Compile

Ctrl + F8

PL/SQL Editor
Compile for Debug

Ctrl + Shift + F8

PL/SQL Editor
Debug

Ctrl + Shift + F10

PL/SQL Editor
Run

Ctrl + F10

Search
Find

Ctrl + F

Search
Find Next/ Previous

F3 / Shift + F3

Search
Find Next/ Prevoius Word at Cursor

Ctrl + F3 / Ctrl + Shift + F3

Search
Incremental Find Forward/ Backwards

Ctrl + E / Ctrl + Shift + E

Search
Global Search

` (grave accent)

Search
Replace

Ctrl + R

Source
Code Assist

Ctrl + Alt + Enter

Source
Collapse/ Expand All

Ctrl + Shift + [ / ]

Source
Collape/ Expand Block

Ctrl + [ / ]

Source
Complete Statement

Ctrl + Shift + Enter

Source
Expand/ Narrow Selection

Ctrl + Shift + = / -

Source
Focus Breadcrumbs

Ctrl + Shift + .

Source
Quick Doc

Ctrl + D

Source
Reformat

Alt + Shift + F

Source
Show Whitespace

Ctrl + Shift + W

View
Breakpoints

Ctrl + Shift + R

View
Components

Ctrl + Shift + P

View
Freeze Content

Ctrl + I

View
Log

Ctrl + Shift + L

View
Refresh

Ctrl + R

Window
Activate Document 1…9

Alt + 19

Window
Assign to Alt+1…9

Alt + Shift + 19

Window
File List

Alt + 0

Window
Left Editor/ Right Editor

Alt + Page Up / Page Down

Window
Next Pane/ Previous Pane

F6 / Shift + F6

Window
Next File/ Previous File

Ctrl + Tab / Ctrl + Shift + Tab

Window
Left Tab/ Right Tab

Shift + F5 / Alt + Shift + F5

Window
Show Editor Menu

Alt + -

Worksheet
Autotrace

F6

Worksheet
Clear

Ctrl + D

Worksheet
Commit

F11

Worksheet
Explain Plan

F10

Worksheet
Rollback

F12

Worksheet
Run Script

F5

Worksheet
Run Statement

Ctrl +Enter (or F9)

Worksheet
SQL History

F8

Worksheet
SQL Tuning Advisor

Ctrl + F12

Worksheet
SQL Worksheet

Alt + F10

Worksheet
TimesTen Index Advisor

Ctrl + Shift + X

Worksheet
Unshared SQL Worksheet

Ctrl + Shift + N

Worksheet
Toggle Case

Ctrl + '

Other
Embed/ Expose

Ctrl + Shift + F7

Other
Format

Ctrl + F7

Other
Popup Descrip

Shift + F4

Other
Context Menu

Shift + F10

Other
Properties

Ctrl + Shift + I

Other
Quick Action

Ctrl + Alt + A

Other
SQL History - append from Next/ Previous

Ctrl + Shift + Arrow Down / Arrow Up

Other
SQL History - replace with Next/ Previous

Ctrl + Arrow Down / Arrow Up

Other
Run File

Ctrl + F11

Other
Build/ Make

Ctrl + Shift + F9

Other
Build/ Rebuild

Alt + Shift + F9

Other
Context Help

F1

Other
Help Backwards/ forward

Ctrl + Alt + Arrow Left / Arrow Right

Code Snippets
CREATE FUNCTION function_name

cf

Code Snippets
CREATE PROCEDURE procedure_name

cp

Code Snippets
CREATE TABLE table ()

ct

Code Snippets
DELETE FROM table WHERE

df

Code Snippets
Insert Into table VALUES ()

II

Code Snippets
SELECT * FROM table

ssf

Similar combinations for other applications


Firebug (Windows)
Open Firebug in window (for some reason sometimes pressing ctrl+f12 again closes Firefox, use ctrl+w to close the Firebug window instead
Managing Firebug

Ctrl + F12


Firebug (Linux)
Open Firebug in window (for some reason sometimes pressing ctrl+f12 again closes Firefox, use ctrl+w to close the Firebug window instead
Managing Firebug

Ctrl + F12


Android Emulator (Windows)
Switch layout orientation portrait/landscape forwards (or 9 on on numeric keyboard with Num Lock off)
Other Device Keys

Ctrl + F12


Visual Studio 2015 (Windows)
Display symbol declaration
Code Editor - IntelliSense and Code Helper

Ctrl + F12


Visual Studio 2015 (Windows)
Display symbol declaration
Coding - IntelliSense and Code Helper

Ctrl + F12


Total Commander 8 (Windows)
Show user defined files
Main Shortcuts

Ctrl + F12


Visual Studio 2015 (Windows)
Display symbol declaration
Code Snippets (Visual C# Scheme) - IntelliSense and Code Helper

Ctrl + F12


Microsoft Word 2007 (Windows)
Choose the Open command (Microsoft Office Button ).
Function key reference: CTRL+Function key

Ctrl + F12


UltraEdit (Windows)
Delete from the cursor to end of line
Edit Menu

Ctrl + F12


Opera (Linux)
Open Settings
Menus

Alt + P / Ctrl + F12


Android Emulator (Linux)
Switch layout orientation portrait/landscape forwards (or 9 on numeric keyboard with Num Lock off)
Other Device Keys

Ctrl + F12


IntelliJ (Linux)
File structure popup
Navigation

Ctrl + F12


IntelliJ (Windows)
File structure popup
Navigation

Ctrl + F12


FL Studio (Windows)
Close all unfocused windows
Window Navigation

Ctrl + F12


Axialis IconWorkshop (Windows)
Automatic reorganization
Window Menu

Ctrl + F12


Autodesk Maya 2015 (Windows)
Covert polygon selection to UVs
Modeling

Ctrl + F12


Autodesk Maya 2017 (Windows)
Covert polygon selection to UVs
Modeling

Ctrl + F12


Dynamics NAV 2015 (Windows)
Select the address bar
Documentaion

Ctrl + F12


Microsoft Projects 2016 (Windows)
Open a project file (display the Open dialog box).
File Management

Ctrl + F12


Microsoft Projects 2016 (Windows)
Display the Open dialog box.
Working with dialog boxes

Ctrl + F12


Microsoft Word 2016 (Windows)
Choose the Open command (Microsoft Office Button ).
All Function Key Shortcuts

Ctrl + F12


JetBrains PyCharm (Windows)
File Structure Popup
Navigation

Ctrl + F12


JetBrains RubyMine (Windows)
File Structure Popup
Navigation Shortcuts

Ctrl + F12


JetBrains RubyMine (Linux)
File Structure Popup
Navigation Shortcuts

Ctrl + F12


Corel WordPerfect X8 (Windows)
Table Formats
63 Shortcuts for Corel WordPerfect X8 (Windows)

Ctrl + F12


Corel Ventura 10 (Windows)
Order Backward One
Alignment of Objects

Ctrl + F12


Corel Quattro Pro X8 (Windows)
Show Properties of Current Spreadsheet
Function Keys

Ctrl + F12


XYplorer (Windows)
Show Toolbar
Function key Shortcuts

Ctrl + F12


Jetbrains CLion (Windows)
File structure popup
Navigation Shortcuts

Ctrl + F12


Delphi 10 (Windows)
View units
193 Shortcuts for Delphi 10 (Windows)

Ctrl + F12


MPS 2017 (Windows)
Display the Structure pop-up window for quick navigation through the current file
Navigation between Source Code

Ctrl + F12


Libreoffice Writer (Windows)
Insert or edit Table
Function Keys

Ctrl + F12


Soundforge (Windows)
Play/Pause
Navigation and Playback

Enter / Ctrl + F12


RStudio (Windows)
Next tab
Source

Ctrl + F12


RStudio (MacOS)
Next tab
Source

Ctrl + F12


Titanium (Windows)
Focus Editor
Quick Access

Ctrl + F12


dbForge SQL Complete
Script object as CREATE/ALTER
General

Ctrl + F12


Xyplorer
Show Toolbar
Window Menu

Ctrl + F12


ChessBase 13
Go to My databases
Database window

Ctrl + F12


RStudio (Mac)
Next tab
Source

Ctrl + F12


RStudio
Next tab
Source

Ctrl + F12


Target 3001! (Windows)
Open Reorganisation Dialog
Function key Shortcuts

Ctrl + F12


Battlezone 98 Redux
Group weapon
Weapons

Ctrl + F12


Adobe Illustrator
Save the document as script files
Work with documents

Ctrl + F12


SuperMemo (Windows)
Repair Collection
129 Shortcuts for SuperMemo (Windows)

Ctrl + F12


Claws Mail
Toggles menu bar visibility
Main window

Ctrl + F12


Tibia
Wild growth
Action bar

Ctrl + F12


PyCharm 2018.2
Display the Structure pop-up window for quick navigation through the current file.
Navigation in source code

Ctrl + F12


Bluebeam Revu
Toggle stay on top
Viewing

Ctrl + F12


CorelDRAW Graphics Suite 2018
Spell Check...
General

Ctrl + F12


KDE Plasma Desktop
Show Desktop
Working with desktop

Ctrl + F12


Microsoft Visual Studio 2017 (Most used shortcuts)
Edit.GoToDeclaration
Edit

Ctrl + F12


Microsoft Word 2016
Choose the Open command
Ctrl + Function keys

Ctrl + F12


Microsoft Visual Studio 2017 (All shortcuts)
Edit.GoToDeclaration
Edit

Ctrl + F12


NetBeans
Inspect members/hierarchy
Coding in Java

Ctrl + F12


IntelliJ IDEA (Windows, Linux)
File structure popup
Navigation

Ctrl + F12


WordPerfect X8
Table Formats
General

Ctrl + F12


LibreOffice Calc
Ungroups the selected data range
Function keys

Ctrl + F12


LibreOffice Writer
Insert or edit Table
Function keys

Ctrl + F12


WinNc
Split files
General

Ctrl + F12


Lingoes
Read selected text aloud
General

Ctrl + F12


Delphi
View units
General

Ctrl + F12


Microsoft Access 2016
Open an existing database
Work with database files

Ctrl + F12


The Bat!
Set access password
Using the account

Ctrl + F12


Blender
Render animation
General

Ctrl + F12


DOSBox
Increase DOSBox cycles (speeds up the emulation)
General

Ctrl + F12


Android Studio
Open file structure pop-up
Navigating and searching

Ctrl + F12


Notepad2
Customize syntax schemes
Syntax scheme, font

Ctrl + F12


Opera
Edit your preferences
Preferences

Ctrl + F12


Scrivener 1.9.9
Show index card keywords
View

Ctrl + F12