Wednesday, February 10, 2010

TOAD KEYBOARD SHORTCUTS

TOAD KEYBOARD SHORTCUTS:
========================================================

F1 ------------- Windows help file

F2 ------------- Toggle full screen editor

Shift+F2-------- Toggle full screen grid

F3---------------Find next occurrence

F4---------------Describe

F5---------------Set or delete a breakpoint in Proc Editor for
PL/SQL debugging or execute as script in SQL Editor.

F6---------------Toggle between SQL Editor and results panel.

F7-------------- Clear all text, trace into Proc Editor

F8---------------Recall previous SQL statement or step over in
Proc Editor for PL/SQL debugging.

F9--------------- Execute statement in SQL Editor compile in Proc Editor

Ctrl+F9---------- Verify statement without execution (parse) in SQL Editor, set parameters in Proc Editor for PL/SQL debugging.

Shift+F9--------- Execute current statement at cursor in SQL Editor or
execute current source in Proc Editor without PL/SQL debugging
F10-------------- Popup menu

F11------------- Run (continue execution) in Proc Editor for PL/SQL debugging

F12-------------- Run to cursor in Proc Editor for PL/SQL debugging.

ctrl+F12--------- Pass SQL or Proc Editor contents to specified external editor

ctrl+alt+B------- Display PL/SQL debugger breakpoints window

ctrl+D----------- Display procedure parameters

ctrl+alt+D------- Display PL/SQL debugger in DBMS output window

ctrl+E----------- Execute explain plan on current statement

ctrl+alt+E------- Display PL/SQL debugger evaluate/modify window

ctrl+G----------- Go to line

ctrl+L----------- Convert text to lowercase

ctrl+M----------- Make code statement

ctrl+N----------- Recall named SQL statement

ctrl+P----------- Strip code statement

ctrl+R----------- Find and replace

shift+ctrl+S---- Save file as

ctrl+alt+S------- Display PL/SQL debugger call stack window

ctrl+T------------ column dropdown

ctrl+U----------- Converts text to uppercase

ctrl+alt+W------- Display PL/SQL debugger watches window

ctrl+shift+z----- Redo last undo

alt+UP----------- Display previous statement

alt+DOWN--------- Display next statement (after alt+UP)

ctrl+HOME-------- In data grids, go to top of the recordset

ctrl+END--------- In data grids, go to end of the recordset

ctrl+TAB--------- Cycle through collection of MDI child windows

ctrl+(period)---- Auto completes tablenames

ctrl+ENTER-------- Execute current SQL (same as shift+F9)

2 comments: