We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, July 19, 2012

Toad shortcuts


Today,Toad is a software application from Quest Software used for development and administration of various relational databases. Sharing some Toad tool shortcut…



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)


njoy the simplicity.......
Atul Singh

No comments :

Post a Comment