Toad and SQL Developer shortcuts for Database Developers

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.

Leave a Comment

Your email address will not be published. Required fields are marked *