Changing SQL and XQuery templates

You can change default SQL and XQuery templates, as well as templates that you created and imported.

In addition to changing the pattern of the template, you can change any of the other information in the template definition, including the template name.

To change an SQL or XQuery template:

  1. Click Window > Preferences.
  2. In the navigation tree of the Preferences window, expand the Data node and the SQL Editor node, and then click Templates.
  3. On the SQL Editor - Templates page, select the template that you want to change, and then click Edit.
  4. In the Edit Template window, change the necessary information.
  5. Click OK. If you change the name of the template, a message box prompts you to specify whether you want to create an additional template with the new name or rename the existing template. Click No. The changed template is shown in the list on the SQL Editor - Templates page.
  6. Click OK in the Preferences window.
The changed template is available for you to use in the SQL editor.
Parent topic: Templates for SQL and XQuery
Related reference
Preferences window - SQL Editor - Templates page
New Template and Edit Template window
Feedback