Predefined Shortcuts


Keyboard shortcuts are one of the features that makes TOAD so powerful and easy to use. TOAD comes with a host of predefined shortcuts. These shortcuts save keystrokes and mouse actions and perform a variety of tasks such as issuing a describe on the current highlighted object, or find (find next , find previous, and so on). The shortcuts differ slightly between the Procedure Editor and the SQL Editor (covered in Chapter 3). This section focuses on the shortcuts for the Procedure Editor only.

Tables 4.1 and 4.2 are handy cross references for all of the Procedure Editor shortcuts. Table 4.1 shows the shortcuts arranged by keystroke, and Table 4.2 shows the shortcuts arranged by description. The third column refers you to the figure in this chapter where the shortcut is illustrated .

F2 or Shift+F2 Toggles output window

F9 Compile

Ctrl+S Save

F11 Run

Ctrl+F9 Set Parameters

F8 Step Over

F7 Trace into

Shift+F8 Trace out

F12 Run to cursor

Ctrl+F5 Add watch

Table 4.1. Procedure Editor Shortcuts by Keystroke

Shortcut

Description

Illustrations

F1

Windows Help File

 

F2

Toggle Error Message Panel

Figure 4.3

F3

Find Next Occurrence

 

Shift+F3

Find Previous Occurrence

 

F4

Describe Table, View, Procedure, Function

Figure 4.23

F5

Set/Delete Break Point

Figure 4.54

F7

Trace Into While Debugging

Figure 4.52

F8

Step Over While Debugging

Figure 4.52

F9

Compile

Figure 4.35

Ctrl+F9

Set Code Execution Parameters

Figures 4.36, 4.50

Shift+F9

Execute Current Source Without Debugging

 

F10 or right-click

Pop-up Menu

Figure 4.4

F11

Execute Current Source with Debugging

Figure 4.36

F12

Execute Current Source to Cursor With Debugging

 

Ctrl+F12

External Editor, Pass Contents

 

Ctrl+A

Select All Text

 

Ctrl+Alt+B

Display Breakpoint Window

 

Ctrl+C

Copy

 

Ctrl+D

Display Procedure Parameters

 

Ctl+Alt+D

Display Debugger in DBMS Output Window

 

Ctrl+F

Find Text

 

Ctrl+G

Goto Line

 

Ctrl+L

Convert Text to Lowercase

 

Ctrl+M

Make Code Statement

 

Ctrl+N

Recall Named SQL Statement

 

Ctrl+O

Open a Text File

 

Ctrl+P

Strip Code Statement

 

Ctrl+R

Find and Replace

 

Ctrl+S

Save File

 

Shift+Ctrl+S

Save File As

Figure 4.38

Ctrl+Alt+S

Display Call Stack Window

 

Ctrl+T

Columns Drop-down

Figure 4.16

Shift+Ctrl+R

Alias Replacement

 

Shift+Ctrl+T

Columns Drop-down no alias

Figure 4.18

Ctrl+Spacebar

Code Templates

Figure 4.27

Ctrl+U

Convert Text to Uppercase

 

Ctrl+V

Paste

 

Ctrl+Alt+W

Display Debugger Watches Window

 

Ctrl+X

Cut

 

Ctrl+Z

Undo Last Change

 

Ctrl+.

Display Pop-up List Of Matching Table Names

Figure 4.16

Shift+Ctrl+Z

Redo Last Undo

 

Ctrl+Tab

Cycles Through the Collection of MDI Child Windows

 
Table 4.2. Procedure Editor Shortcuts by Description

Description

Keystroke

Illustration

Alias Replacement

Shift+Ctrl+R

 

Code Templates

Ctrl+Spacebar

Figure 4.27

Columns Drop-down

Ctrl+T

Figure 4.16

Columns Drop-down no alias

Shift+Ctrl+T

Figure 4.18

Compile

F9

Figure 4.35

Convert Text to Lowercase

Ctrl+L

 

Convert Text to Uppercase

Ctrl+U

 

Copy

Ctrl+C

 

Cut

Ctrl+X

 

Cycle through the Collection of MDI Child Windows

Ctrl+Tab

 

Describe Table, View, Procedure, Function, or Package

F4

Figure 4.23

Display Breakpoint Window

Ctrl+Alt+B

 

Display Call Stack Window

Ctrl+Alt+S

 

Display Debugger in DBMS Output Window

Ctl+Alt+D

 

Display Debugger Watches Window

Ctrl+Alt+W

 

Display Pop-up List of Matching Table Names

Ctrl+ .

Figure 4.16

Display Procedure Parameters

Ctrl+D

 

Execute Current Source to Cursor With Debugging

F12

 

Execute Current Source with Debugging

F11

Figures 4.4, 4.36

Execute Current Source Without Debugging

Shift+F9

Figure 4.36

External Editor, Pass Contents

Ctrl+F12

 

Find and Replace

Ctrl+R

 

Find Next Occurrence

F3

 

Find Previous Occurrence

Shift+F3

 

Find Text

Ctrl+F

 

Goto Line

Ctrl+G

 

Make Code Statement

Ctrl+M

 

Open a Text File

Ctrl+O

 

Paste

Ctrl+V

 

Pop-up Menu

F10 or right-click

 

Recall Named SQL

Ctrl+N

 

Redo Last Undo

Shift+Ctrl+Z

 

Save File

Ctrl+S

Figure 4.38

Save File As

Shift+Ctrl+S

Figure 4.38

Select All Text

Ctrl+A

 

Set Execution Parameters

Ctrl+F9

Figure 4.36

Set/Delete Break Point

F5

Figure 4.54

Step Over While Debugging

F8

Figure 4.52

Strip Code Statement

Ctrl+P

 

Trace Into While Debugging

F7

Figure 4.52

Toggle Error Message Panel

F2

Figure 4.3

Undo Last Change

Ctrl+Z

 

Windows Help File

F1

 


TOAD Handbook
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net