Changing routine templates

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

About this task

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.

Procedure

To change a routine template:

  1. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > Routines > 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.

Results

The changed template is available for you to use in the in the routine creation wizards.

Feedback