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 |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center