Creating routine templates

You can create routine templates to use as a starting point when you create stored procedures or user-defined functions with wizards.

About this task

The template pattern can contain any valid routine syntax and can include variables. The variables from which you can choose are specific to the context of the pattern.

Procedure

To create a routine template:

  1. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > Routines > Templates.
  3. On the Templates page, click New.
  4. In the New Template window, specify the name of the template.
  5. Type a short description of the template.
  6. Type the template pattern. To add a variable at the insertion point, click Insert Variable, and then select the variable that you want in the pop-up window.
  7. Click OK. Your template is added to the list on the Templates page in the Preferences window.
  8. Click OK in the Preferences window.

Results

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

Feedback