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.