Shortcut Key | Function |
---|---|
F1 | Windows Help File |
F2 | Toggle Full screen Editor |
F3 | Find Next Occurrence |
SHIFT+F3 | Find Previous Occurrence |
F4 | Describe Object at cursor. Describe Table, View, Procedure, Function, or Package in popup window |
F5 | Execute as Script |
F6 | Toggle between Editor and Results tabs |
F7 | Clear All Text |
F8 | Toggle Recall SQL statement panel |
F9 | Execute statement |
CTRL+ F9 | Describes statement at cursor |
SHIFT+ F9 | Execute snippet at cursor |
F10 | Popup (right-click) Menu |
F11 | Execute code without using the Debugger |
CTRL+ A | Select All Text |
CTRL+ C | Copy |
CTRL+E | Execute Explain Plan on the Current Statement |
CTRL+F | Find Text |
CTRL+G | Goto Line |
CTRL+H | Highlight snippet |
CTRL+I | Init caps for highlighted code. |
CTRL+L | Converts Text to Lowercase |
CTRL+M | Make Code Statement |
CTRL+N | Recall Named SQL Statement |
CTRL+O | Opens File |
CTRL+P | Strip Code Statement |
CTRL+R | Find and Replace |
CTRL+S | Save File |
SHIFT+CTRL+S | Save File As |
CTRL+T | Columns Dropdown |
CTRL+U | Converts Text to Uppercase |
CTRL+V | Paste |
CTRL+X | Cut |
CTRL+Z | Undo Last Change |
CTRL+. (period) | Display popup list of matching tablenames |
SHIFT+CTRL+Z | Redo Last Undo |
ALT+UP+ | Display Previous Statement |
ALT+DOWN | Display Next Statement (after ALT+UP) |
ALT+PageUP | Navigate to the previous tab in the editor |
ALT+PageDOWN | Navigate to the next tab in the editor |
CTRL+ALT+PAGEUP | Navigate to the previous results panel tab |
CTRL+ALT+PAGEDOWN | Navigate to the next results panel tab |
CTRL+HOME | In the data grids, goes to the top of the recordset |
CTRL+END | In the data grids, goes to the end of the recordset |
CTRL+SPACE | Display the code template pick list |
CTRL+TAB | Cycles through the collection of MDI Child windows |
많이 사용하는 단축키는 다음과 같다.
ESC: 열린 윈도우 닫기
F1: 모든 단축키를 보여준다.
F2: FULL SCREEN
F4: Table, View, Proc, Funct, Package를 DESC(테이블명에 커서를 둔 상태에서 해야함)
F6: SQL Editor와 결과창간의 전환
F7: 화면을 모두 CLEAR
F8: 실행했던 SQL들의 HISTORY
F9: 모든 쿼리 실행(Ctrl+Enter는 현재 쿼리만 실행)
Ctrl+F9: 실제 쿼리를 실행하지 않고 validate함
Ctrl+. : table Completion (매칭되는 테이블목록 출력)
Ctrl+T : 컬럼목록 표시
Alt+Up : History Up
Alt+Down: History Down
Ctrl+Tab: Tab 전환
Ctrl+Enter : 현재 커서의 SQL문 실행
F5 : SQL*PLUS의 출력과 같음
F9 : SQL문 실행하여 Grid에 출력
[출처] Toad Editor 단축키|작성자 길상
'Other > DB' 카테고리의 다른 글
[MAC] h2 database 연결 오류(90149) (3) | 2019.11.25 |
---|---|
PL/SQL SQL PLUS상에서 STORED PROCEDURE 소스 확인 방법 (0) | 2012.08.14 |
PL/SQL 프로시저 (procedure) (0) | 2012.08.14 |
MySQL : 해당 필드에 중복된 값 찾기 (0) | 2012.06.15 |
mysql - DATE_FORMAT & TIME_FORMAT (1) | 2012.06.12 |