Toad 단축키.

DB 2008. 4. 19. 03:52

Table 3.1 SQL Editor Shortcuts by Keystroke

Shortcut

Description

Illustration

F1

Windows Help File


F2

Toggle Output Window

Figure 3.2

Shift+F2

Toggle Data Grid Window


F3

Find Next Occurrence


Shift+F3

Find Previous Occurrence


F4

Describe Table, View, Procedure, Function

Figure 3.26

F5

Execute SQL as a script

Figure 3.34

F6

Toggle between SQL Editor and Results Panel

Figure 3.1

F7

Clear All Text


F8

Recall Previous SQL Statement


F9

Execute Statement

Figure 3.33

Ctrl+F9

Set Code Execution Parameters

Figure 3.33

Shift+F9

Execute Current SQL statement at Cursor


F10 or right-click

Pop-up Menu

Figures 3.4, 3.10

Ctrl+F12

External Editor, Pass Contents

Figures 3.5, 3.6

Ctrl+A

Select All Text


Ctrl+C

Copy


Ctrl+E

Execute Explain Plan on the Current Statement

Figure 3.41

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 3.18

Ctrl+T

Columns Drop-down


Shift+Ctrl+R

Alias Replacement


Shift+Ctrl+T

Columns Drop-Down no alias

Figure 3.19

Ctrl+Spacebar

Code Templates

Figure 3.30

Ctrl+U

Converts Text to Uppercase


Ctrl+V

Paste


Ctrl+X

Cut


Ctrl+Z

Undo Last Change


Ctrl+.

Display Pop-up List of Matching Table Names

Figure 3.16

Shift+Ctrl+Z

Redo Last Undo


Alt+Up Arrow

Display Previous Statement

Figure 3.7

Alt+Down Arrow

Display Next Statement (After Alt+Up Arrow)

Figure 3.7

Ctrl+Home

In the data grid: goes to the top of the record set


Ctrl+End

In the data grid: goes to the end of the record set


Ctrl+Tab

Cycles through the Collection of MDI Child Windows



TIP

The competent TOAD user makes use of Shift+F9 to execute SQL statements one at a time out of a script, and F8 to recall the previous SQL statement. The TOAD user also makes use of cut and paste to move code between TOAD windows.

Shift+F9 executes single SQL statements.

F8 recalls the previous SQL statement.

Table 3.2 SQL Editor Shortcuts by Description

Description

Shortcut

Illustration

Alias Replacement

Shift+Ctrl+R


Clear All Text

F7


Code Templates

Ctrl+Spacebar

Figure 3.30

Columns Drop-down

Ctrl+T

Figure 3.18

Columns Drop-down no alias

Shift+Ctrl+T

Figure 3.19

Convert Text to Lowercase

Ctrl+L


Convert Text to Uppercase

Ctrl+U


Copy

Ctrl+C


Cut

Ctrl+X


Cycles through the Collection of MDI Child Windows

Ctrl+Tab


Describe Table, View, Procedure, Function, or Package

F4

Display Next Statement (After Alt+Up Arrow)

Alt+Down Arrow

Figure 3.7

Display Previous Statement

Alt+Up Arrow

Figure 3.7

Display Pop-up List of Matching Table Names

Ctrl+.

Figure 3.16

Execute Current SQL Statement at Cursor

Shift+F9


Execute SQL as a Script

F5

Figure 3.35

Execute Explain Plan on the Current SQL Statement

Ctrl+E

Figure 3.41

Execute SQL Statement

F9

Figure 3.34

External Editor, Pass Contents

Ctrl+F12

Figure 3.5

Find and Replace

Ctrl+R


Find Next Occurrence

F3


Find Previous Occurrence

Shift+F3


Find Text

Ctrl+F


Goto Line

Ctrl+G


In the data grid: goes to the end of the record set

Ctrl+End


In the data grid: goes to the top of the record set

Ctrl+Home


Make Code Statement

Ctrl+M


Open a Text File

Ctrl+O


Paste

Ctrl+V


Pop-up Menu

F10 or RT-Mouse

Figures 3.4, 3.10

Recall Named SQL

Ctrl+N


Recall Previous SQL Statement

F8


Redo Last Undo

Shift+Ctrl+Z


Save File

Ctrl+S

Save File As

Shift+Ctrl+S

Select All Text

Ctrl+A


Strip Code Statement

Ctrl+P


Toggle between SQL Editor and Results Panel

F6

Figure 3.1

Toggle Full Screen Editor

F2

Figure 3.2

Undo Last Change

Ctrl+Z


Verify Statement Without Execution (Parse)

Ctrl+F9


Windows Help File

F1


 
Posted by '김용환'
,