100 Popular Oracle Keyboard Shortcuts

Database management can be difficult and cumbersome. Finding the best ways to organize your workflow can also be tiring. For Oracle users, mastering shortcuts can significantly enhance productivity, streamline workflows, and reduce the time spent on routine tasks.

This article explores a selection of indispensable shortcuts that can make navigating Oracle more intuitive and effective. Whether you’re a seasoned DBA or a novice user, these shortcuts will help you optimize your operations and maximize your Oracle experience.

Basic Mode Data Management Shortcuts

New record – CTRL+ALT+N

New record using Quick Fill template – CTRL+K

New record using last used Quick Fill template – CTRL+J

Apply Quick Fill template to record – CTRL+Q

Copy record – CTRL+ALT+C

Save record – CTRL+SHIFT+S

Delete record – CTRL+ALT+D

Undo record – CTRL+ALT+U or ESC

Select all – CTRL+ALT+A

Invoke selection dialog box – CTRL+ALT+P

Open the calendar control – CTRL+ALT+P

Open the calculator control – CTRL+ALT+P

Open a drop-down list – CTRL+ALT+P

Save and close the calendar control – CTRL+1

Save and close the calculator control – CTRL+1

Close the calendar control without saving – CTRL+2 or ESC

Close the calculator control without saving – CTRL+2 or ESC

Toggle the Toolbar – SHIFT+Z

Toggle the document view between Actual size, Fit width, and Fit page – Z

Zoom out incrementally – –

Zoom in incrementally – +

Toggle between standard view and full-screen mode – f

Basic Mode Record Navigation Shortcuts

Drill down into record – CTRL+SHIFT+SPACE

Go to the previous record – CTRL+SHIFT+,

Go to the next record – CTRL+SHIFT+.

Go to the previous record set – CTRL+ALT+, (comma)

Go to the next record set – CTRL+ALT+.

Go to the first record set – CTRL+ALT+F

Go to the last record set – CTRL+ALT+L

Basic Mode Query Shortcuts

New query – CTRL+ALT+Q

Execute query – CTRL+ALT+ENTER

Refine query – CTRL+ALT+G

Save query with different name – CTRL+ALT+S

Launch query assistant – CTRL+ALT+Z

Cancel query – CTRL+SHIFT+9

Basic Mode General Navigation Shortcuts

Go to Site Map – CTRL+SHIFT+A

Go to application-level menu – CTRL+ALT+M

Go back – ALT+LEFT ARROW

Go forward – ALT+RIGHT ARROW

Go to screen tabs – CTRL+SHIFT+T

Go to view tabs – CTRL+ALT+T

Go to subtabs – CTRL+ALT+V

Open menu button pop-up on list or form – CTRL+SHIFT+M

Go to next list or form – CTRL+SHIFT+]

Go to previous list or form – CTRL+SHIFT+[

Open Search Center – CTRL+SHIFT+F

Open iHelp – CTRL+SHIFT+E

Go to the iHelp pane – CTRL+SHIFT+0

Go to previous iHelp topic – CTRL+SHIFT+5

Go to next iHelp topic – CTRL+SHIFT+6

Open Tasks – CTRL+SHIFT+Y

Open How Do I… – CTRL+SHIFT+E

Go to Computer Telephony Integration (CTI) toolbar – SHIFT+F2

Go to message broadcast bar – SHIFT+F3

Go to previous page – CTRL+ALT+, (comma)

Go to next page – CTRL+ALT+. (period)

Go to tree applet – CTRL+SHIFT+4

Go to previous tree applet node – CTRL+SHIFT+1

Go to next tree applet node – CTRL+SHIFT+2

Close menu button pop-up on list or form – CTRL+ALT+O

Go to the Show drop-down list – CTRL+SHIFT+V

Go to the Reports drop-down list – CTRL+SHIFT+R

Search for Content – /

Expand/collapse navigation panel – G+N

Go to the Flags page – G+F

Basic Mode Help Shortcuts

Display online help – CTRL+ALT+H

Display information about record – CTRL+ALT+K

Access system information – CTRL+ALT+J

View information (name and summary) – CTRL+ALT+Z

Basic Mode Communication Shortcuts

Send letter – CTRL+SHIFT+L

Send email – CTRL+ALT+1

Send fax – CTRL+ALT+2

Send page – CTRL+ALT+3

Send wireless message – CTRL+ALT+4

Create a new conversation – N

Mark All Messages in Selected Conversation As Read – M

Mark or Clear Selected Conversation As Favorite – V

Insert a reference (to move the message toolbar) – Alt+Shift+t

Insert a Reference – TAB

General Messaging Shortcuts

Post a Message – T

Reply to Selected Message – R

Edit Selected Message – E

Like Selected Message – L

Clear Flag for You on Selected Message – C

Manage Flags for Selected Message – F

Mark Selected Message as Read – M

Next Message – J

Find Next Item (based on selected find criteria) – X

Find Previous Item (based on selected find criteria) – P

Basic Mode App Management Shortcuts

Synchronize database – CTRL+ALT+5

Update audit cache – CTRL+ALT+X

Connect as new mobile user – CTRL+SHIFT+W

Log out – CTRL+SHIFT+X

General Calendar Shortcuts

Open the date picker if closed – Ctrl+Home

Move to previous/next month – Page Up/Page Down

Move to previous/next year – Ctrl+Page Up/Page Down

Move to previous/next day – Ctrl+Command+Left/Right

Move to the previous/next week – Ctrl+Command+Up/Down

Move to the current month – Ctrl+Command+Home

Select the focused date – Enter

Close without selection – ESC

Close the calendar, and erase selections – Ctrl+Command+End

Stop copying and pasting common SQL queries in Oracle

If you find yourself typing (or copying and pasting) the same things over and over into Oracle, you’re probably thinking there has to be a better way.

TextExpander is a powerful tool that can simplify the way Oracle users handle repetitive tasks and complex queries. By allowing users to create snippets—small pieces of reusable text that can be quickly inserted with a few keystrokes—TextExpander significantly boosts productivity and accuracy. This means you can spend less time writing out common SQL queries, error messages, or database commands and more time focusing on critical, value-added tasks.

Moreover, TextExpander syncs across multiple devices. Oracle users can access their snippets anywhere. This ensures whether you work in your office, at home, or at a coffee shop, you are getting the valuable assets you need.

TextExpander empowers Oracle users to work smarter, not harder, making it an invaluable addition to any Oracle toolkit.

Text Shortcuts Everywhere You Work

TextExpander lets you type a short Snippet that expands into a longer bit of text. It works in Oracle and every app you work in.

Start Free 30-Day Trial