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 |