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. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > SQL and XQuery Editor > Templates.
  3. On the 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 Templates page.
  6. Click OK in the Preferences window.
The changed template is available for you to use in the SQL and XQuery editor.
Related reference
Preferences window - SQL and XQuery Editor - Templates page
New Template and Edit Template window

Feedback