New Template and Edit Template window

Use this window to define a new SQL or XQuery template or to modify the existing SQL or XQuery template that you selected on the SQL and XQuery Editor - Templates page in the Preferences window.
Name
Identifies the template. The text in this box is displayed in the Name column on the Templates page of the Preferences window. The name of the template and its description are displayed in content assist in the SQL and XQuery editor.
Context
If you are defining a new template, select whether it is a template for an SQL or an XQuery statement.
Automatically insert
Select to automatically insert the template in your statement after you type the template name in the editor and press Ctrl + Space. This feature is functional only if the template name is unique.
Description
Provides a brief explanation of the template. The text in this box is displayed in the Description column on the Templates page of the Preferences window. The name of the template and its description are displayed in content assist in the SQL and XQuery editor.
Pattern
Specify the code that you want to include in the template.
Insert Variable
Add the variable that you select in the pop-up window to the pattern at the insertion point. The variables that are displayed in the pop-up window are specific to the context of your pattern.

Feedback