Toad 사용가이드

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