Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Code Templates

Insert ready-made code segments into any active editor window.

Action Description

Insert code from a template into an active editor window.

  1. In the editor, place the cursor where you want to insert the code segment.
  2. Choose one of the following:
    • Type the shortcut key to the code template.
    • Type the full or partial name of the code template and press Ctrl+J to either insert the matching code template or select from a list of matches.
    • Press Ctrl+J. Select the template name from the drop-down list and press Enter.

Add / Edit / Delete code templates.

Click View | Code Templates | Edit Code Templates. This opens the Code Shortcuts And Templates Dialog

Each template is a file in the SQL Navigator installation Templates directory.

The maximum number of templates allowed, including preformatted templates, is 100.

 

Standard code routines for which templates have been provided:

Code Description

Shortcut Key

Basic Loop Statement

Shift+Ctrl+L

Boolean Statement

Shift+Ctrl+B

Close Cursor Statement

Shift+Ctrl+C

DBMS_OUTPUT.Put_Line

Shift+Ctrl+D

Exception

Shift+Ctrl+E

Exit When Statement

Shift+Ctrl+X

For Loop Statement

Shift+Ctrl+F

GOTO Label Statement

Shift+Ctrl+G

IF Statement

Shift+Ctrl+A

MLSLABEL Statement

Shift+Ctrl+M

Number Statement

Shift+Ctrl+N

Open_Cursor Statement

Shift+Ctrl+O

Raise_Exception

Shift+Ctrl+R

SQLCODE Statement

Shift+Ctrl+S

VARCHAR2 Statement

Shift+Ctrl+V

Variable_name

Shift+Ctrl+T

While Condition Statement

Shift+Ctrl+W

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating