You can use templates to insert standard code
patterns into your SQL and XQuery statements in the SQL and XQuery
editor.
As you type an expression or clause in an SQL
or XQuery statement, you can select from among code templates that
you want to insert in the statement.
Before you begin
- The template that you want to use must be enabled in the list
of templates on the SQL and XQuery Editor - Templates page in the
Preferences window.
- The SQL or XQuery statement must be open in the SQL and XQuery
editor.
Procedure
To use a template in an SQL or XQuery statement:
- In the SQL and XQuery editor, position the pointer where
you want to insert the template, and then type the first few letters
or the full name of the template. If you want to automatically
insert a template for which the Auto Insert feature
is on, type the full name.
- Press Ctrl + Space. If the template is not automatically
inserted, perform the following steps in the content assist window:
- Optional: To see the code pattern for a
template that is listed, click the template in the list. The pattern is displayed in the lower part of the window.
- To select a template, double-click it in the list.
If you do not see the template that you want to use in the
content assist window, the template might not be enabled.
Results
The code in the template pattern is inserted in the SQL and
XQuery editor.