| S.No. |
Shortcut |
|
Functionality |
|
Toad |
SQL Developer |
|
| 1 |
Ctrl + Enter |
Ctrl + Enter |
Executing Query or selected script (multiple queries execution is not available in Toad) |
| 2 |
F9 |
F9 |
Executing Query or selected script (multiple queries execution is not available in Toad) |
| 3 |
F4 |
Shift + F4 |
Viewing Object properties i.e. Code of Functions/Packages/procedures and Columns/Data/idexes/grants etc. of Tables |
| 4 |
Ctrl + . (dot) |
Ctrl + Spacebar |
For object (tables/Function/procedures/packages etc.) suggestions |
| 5 |
EDIT |
|
EDIT keyword before table/view name to edit the appeared data. Ex: edit employees where employee_id=7633 |
| 6 |
Ctrl + R |
Ctrl + R |
Replacing certain text with another. Similar to Ctrl + H in text editors. |
