SQL Navigator for Oracle 7.4 - Installation Notes

Create your own code templates. Edit or delete existing code templates. Change the shortcut key definitions attached to a template.

Option

Description

Templates

Click on a template to select it.

Column

Description

Name

The name of the template. A template name is a single word with no spaces.

You cannot change a template name. Instead, you can delete an existing template and create another like it with a different name.

Description

A short description of the template.

Click in the Description field to edit it.

Shortcut key

The shortcut key combination used to insert the template code into an editor.

Click in the field to change the Shortcut key. Select from those available. To have no shortcut key select None.

Code

View / Edit the SQL code for the selected template.

Add

Create a new template.

Delete

Delete the selected template.

You cannot delete all the templates. There must be at least one template remaining in the Code Shortcuts and Templates dialog.

Default Templates

Name	Description	Code	Shortcut Key
Basic Loop	Basic Loop Statement	LOOP statements; END LOOP;	SHIFT+CTRL+L
Boolean	Boolean Statement	Boolean;	SHIFT+CTRL+B
Close Cursor	Close Cursor Statement	CLOSE cursor_name;	SHIFT+CTRL+C
DBMS_PutLine	DBMS_OUTPUT.Put_Line	DBMS_OUTPUT.Put_Line(string);	SHIFT+CTRL+D
Exception	Exception Statement	EXCEPTION WHEN exception_name THEN statements; WHEN no_data_found THEN statements; WHEN others THEN— Handles all exceptions statements;	SHIFT+CTRL+E
Exit_When	Exit When Statement	EXIT WHEN condition_is_true ; -- To exit loop	SHIFT+CTRL+X
For_Loop	For Loop Statement	FOR J IN 1..12 LOOP statements; END LOOP;	SHIFT+CTRL+F
GOTO_Label	GOTO Label Statement	GOTO label_name ;	SHIFT+CTRL+G
IF	IF Statement	IF condition_is_true THEN statements;	SHIFT+CTRL+A
MLSLABEL	MSLABEL Statement	MSLABEL;	SHIFT+CTRL+M
Number	Number Statement	NUMBER( precision , scale ),	SHIFT+CTRL+N
Open_Cursor	Open_Cursor Statement	OPEN cursor_name ;	SHIFT+CTRL+O
Raise_Exception	Raise_Exception	RAISE exception_name ;	SHIFT+CTRL+R
SQLCODE	SQLCODE Statement	SQLCODE;	SHIFT+CTRL+S
VARCHAR2	VARCHAR2 Statement	VARCHAR2( size ),	SHIFT+CTRL+V
Variable_name	Variable_name	variable_name ColName%TYPE;	SHIFT+CTRL+T
While_Condition	While Condition Statement	WHILE condition_is_true LOOP statements; END LOOP ;	SHIFT+CTRL+W
Unassigned			SHIFT+CTRL+H
Unassigned			SHIFT+CTRL+J
Unassigned			SHIFT+CTRL+K
Unassigned			SHIFT+CTRL+P
Unassigned			SHIFT+CTRL+Q
Unassigned			SHIFT+CTRL+Y
Unassigned			SHIFT+CTRL+Z