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 |
The Code Test panel automates the process of testing PL/SQL programs.
To open the Code Test module
Icon | Tool Tip | Description |
---|---|---|
Open and Select Object | Opens the Select DB Object Dialog. | |
Refresh | Refresh the list of test cases against the current object. | |
Create New Test Case |
Opens Test Case Properties. Create a new test case. The first time you create a test case, you are prompted to install the Code Tester for Oracle repository. Installation of this repository is required. Complete the wizard that is launched. | |
Edit Test Case | Opens Test Case Properties. Includes the properties of the highlighted test case. | |
Clone Test Case | Opens Test Case Properties. Renames the test case. Includes the properties of the highlighted test case. | |
Run Selected Test Cases |
Runs the selected test cases.
As test cases are run, the status of each is shown. |
|
TIP:
|
You describe the expected behavior of a program and then SQL Navigator generates the required code for the test case.
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Test Name | The name of the test case selected or a new name. This field is editable. | ||||||
Parameter, Input & Expected Output | Configure input parameters and expected outputs. | ||||||
Test & Result | |||||||
Exception Outcome |
| ||||||
Elapsed Time Outcome |
|
Search stored programs, triggers and views for a character string in the source code.
|
TIP: You can use this utility to perform a quick "where-used" impact analysis. |
Open the Database Source Code Search dialog
Select Search | Code Search.
Define the search criteria
You can stop/suspend the search from the Session Menu or toolbar.
Now objects have been found
Take actions on found object(s)
Icon | Action | Description |
---|---|---|
Edit |
Double click on the object. The object opens in the corresponding editor with the cursor at the line containing the search string. For more information, see Visual Object Editors. | |
Describe |
View Describe information on the object. Right-click on a row in the results set to see Describe information. | |
Add to Project Manager |
Save a shortcut to the code location. Drag the selection from the result list to the Project Manager. | |
Source Preview |
Open Source Preview. Select found text objects to view their source code. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center