Chat now with support
Chat with Support

SQL Navigator for Oracle 7.6 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Code Shortcuts And Templates Dialog

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

Code Test

The Code Test panel automates the process of testing PL/SQL programs.

To open the Code Test module

  1. Open a procedure or function to test in the Code Editor.
  2. Click Tools | Code Test
  3. All test cases currently defined for the procedure / function are displayed. Packages are grouped by entry point.
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.

  • Test Case Selected
  • Test Case Not Selected

As test cases are run, the status of each is shown.

 

TIP:

  • Right click on the test case for further options.
  • Use the search facility to search for test cases by name or parameter.
  • Test cases created in SQL Navigator can also be used in Code Tester for Oracle.

Test Case Properties

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

Field Description
No Exception Select if you do not expect the test to raise an exception.
Exception Expected

Select if you expect the test to raise an exception.

Fill in the expected Error Code as a number.

Elapsed Time Outcome

Field Description
Check Select to test the time taken to execute the code.
Time (ms) The maximum time allowed for the code to complete execution (in milliseconds).

Database Source Code Search Dialog

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

  1. From the What tab define the search string.
  2. From the Where tab select the schema and object type.
  3. Click Search.

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating