Restoring removed SQL and XQuery templates

If you remove one or more default templates from the list on the SQL and XQuery Editor - Templates page in the Preferences window, you can return them to the list.

About this task

A default template is restored to its state at the time of its removal. That is, if you modified a default template prior to removing it, the modified version of the template is restored.

You can restore only default templates. You cannot restore templates that you create or import. You cannot restore removed default templates selectively. All of the removed default templates are restored.

Procedure

To restore removed SQL or XQuery templates:

  1. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > SQL and XQuery Editor > Templates.
  3. On the Templates page, click Restore Removed. If the button is not available, no default templates are removed. The default templates that you removed previously are listed on the Templates page again.
  4. Click OK in the Preferences window.

Results

The restored templates are available in your workbench for you to use in the SQL and XQuery editor.

Feedback