Chat now with support
Chat with Support

Quest has tools and processes in place to identify, protect, detect, and remediate vulnerabilities and incidents when they occur, including external security partners. As part of our standard security operations, Quest does not use CrowdStrike in any of our operations. We are reviewing our third parties, and so far, there is minimal affect. It is Quest's policy not to provide further technical details unless they directly impact customer data.

SQL Navigator for Oracle 7.4 - Release Notes

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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating