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.
| ||||||||
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. |
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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center