Reverting changed default SQL and XQuery templates

If you change the definition of default SQL and XQuery templates, you can revert the templates to their original definition.

When you revert an SQL or XQuery template, you reset its definition to its state at the time of installation.

To revert a changed default 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 changed default template that you want to revert. If you want to revert more than one changed default template, use the Ctrl or Shift key to select multiple templates.
  4. Click Revert to Default. If the button is not available, none of the selected default templates has changed.
  5. Click OK in the Preferences window.
The changed default templates revert to their original definition.

Feedback