Insert ready-made code segments into any active editor window.
| Action | Description | 
|---|---|
| 
 Insert code from a template into an active editor window.  | 
  | 
| 
 Add / Edit / Delete code templates.  | 
 Click View | Code Templates | Edit Code Templates. This opens the Code Shortcuts And Templates Dialog Each template is a file in the SQL Navigator installation Templates directory. The maximum number of templates allowed, including preformatted templates, is 100.  | 
| 
 Code Description  | 
 Shortcut Key  | 
|---|---|
| 
 Basic Loop Statement  | 
 Shift+Ctrl+L  | 
| 
 Boolean Statement  | 
 Shift+Ctrl+B  | 
| 
 Close Cursor Statement  | 
 Shift+Ctrl+C  | 
| 
 DBMS_OUTPUT.Put_Line  | 
 Shift+Ctrl+D  | 
| 
 Exception  | 
 Shift+Ctrl+E  | 
| 
 Exit When Statement  | 
 Shift+Ctrl+X  | 
| 
 For Loop Statement  | 
 Shift+Ctrl+F  | 
| 
 GOTO Label Statement  | 
 Shift+Ctrl+G  | 
| 
 IF Statement  | 
 Shift+Ctrl+A  | 
| 
 MLSLABEL Statement  | 
 Shift+Ctrl+M  | 
| 
 Number Statement  | 
 Shift+Ctrl+N  | 
| 
 Open_Cursor Statement  | 
 Shift+Ctrl+O  | 
| 
 Raise_Exception  | 
 Shift+Ctrl+R  | 
| 
 SQLCODE Statement  | 
 Shift+Ctrl+S  | 
| 
 VARCHAR2 Statement  | 
 Shift+Ctrl+V  | 
| 
 Variable_name  | 
 Shift+Ctrl+T  | 
| 
 While Condition Statement  | 
 Shift+Ctrl+W  |