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.
Prerequisites:- 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.
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.
The code in the template pattern is inserted in the SQL and XQuery editor.