SQLDev KB OS X: SQLDev stands for SQL Developer, which provides powerful editors for working with SQL, PL/SQL, stored Java procedures, and XML. You can run queries, generate execution plans, export data to the desired format, execute, debug, test, and document your database programs, and much more with the SQL developer.
It is completely free and open-source software developed by Oracle. With this app, you can simplify the development and management of Oracle Database in both traditional and cloud deployments.
In this article, you will learn shortcuts for SQLDev KB OS X. Use these shortcuts to save your working time.
Last Updated on Feb 22, 2022.
SQL Worksheet Shortcut Keys:
In the below table, you will learn shortcuts and their functions of the SQL worksheet. Use these shortcuts to save your working time.
| Shortcut | Function |
|---|---|
| Ctrl+Enter | This shortcut is used to execute the query. |
| Ctrl+Space | In order to use Completion Insight, you can use this shortcut. |
| Ctrl+` | By using this shortcut, you can toggle the case. |
| Ctrl+F12 | To use the DESC, you can use this shortcut. |
| ⌘ Cmd+Up/⌘ Cmd+Down | Use this shortcut to make a SQL recall. |
| ⌘ Cmd+Shift+Up /⌘ Cmd+Shift+Down |
It is used to make recall to append. |
| ⌘ Cmd+Shift+N | If you want to open the unshared worksheet, you can use this shortcut. |
| ⌘ Cmd+⌥ Option+/ | Use this shortcut to toggle the comment. |
| F5 | If you want to execute the script, you can use this shortcut. |
| F10 | Make use of this shortcut to explain the plan. |
| F6 | Press this key to Auto trace the worksheet. |
| F8 | By pressing this key, you can view the SQL History. |
SQLcl Shortcut Keys:
In the below table, you will learn shortcuts and their functions of SQLcl. Please use these shortcuts wisely.
| Shortcut | Function |
|---|---|
| Ctrl+R | If you want to run the buffer immediately, you can use this shortcut. |
| Ctrl+W | It is used to go to the top of the buffer. |
| Ctrl+S | In order to go to the bottom of the buffer, you can use this shortcut. |
| Ctrl+A | Make use of this shortcut to go to the start of the line. |
| Ctrl+E | This shortcut is used to go to the end of the line. |
| Ctrl+L | Use this shortcut to clear the screen. |
| Tab | By pressing this key, you can make the File/SQL completion. |
Verdict:
You can use these shortcuts for both Windows 10 and Windows 11. Kindly make sure to use the shortcuts properly.
From this article, you will learn a List of Keyboard Shortcuts for SQLDev KB OS X. Please feel free to state your query or feedback for the above article. Thank You!!