Creating SQL and XQuery templates from existing templates

If you want to create an SQL or XQuery template with a pattern that is similar to the pattern of an existing template, you can base the new template on the existing template definition.

About this task

You can base the new template on the definition of a default template, a template that you created, or a template that you imported.

Procedure

To create an SQL or XQuery template from an existing 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 on which you want to base your new template, and then click Edit.
  4. In the Edit Template window, change the name of the template and its description, and then use the pattern of the existing template to specify the pattern for your new template.
  5. Click OK. 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 Yes. Your template is added to the list on the Templates page.
  6. Click OK in the Preferences window.

Results

The new template is now available for you to use in the SQL and XQuery editor.

Feedback