Exporting routine templates

If you create routine templates to use in the SQL and XQuery editor, you can share your templates with team members by exporting them.

About this task

Your team members can import into their workbench the routine templates that you export from your workbench.

Procedure

To export 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 the template that you want to export.

    If you want to export more than one template, use the Ctrl or Shift key to select multiple templates. You can use this method to create a master template file that contains all of the routine templates that you want your team members to use.

  4. Click Export, type the name of the file for the exported templates, browse to the directory where you want to store the file, and then click Save.
  5. Click OK in the Preferences window.

Results

You now can share the file that contains the template or templates that you exported with your team members.

Feedback