Inserting code templates in SQL and XQuery statements

You can use templates to insert standard code patterns into your SQL and XQuery statements in the SQL and XQuery editor.
Before you begin

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:
About this task

To use a template in an SQL or XQuery statement:

  1. 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.
  2. Press Ctrl + Space. If the template is not automatically inserted, perform the following steps in the content assist window:
    1. 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.
    2. 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.

Feedback