In addition to adding new templates by using the New Template
window, you can import existing SQL and XQuery templates through the
SQL and XQuery Editor - Templates page of the Preferences window.
About this task
You can import into your workbench SQL and XQuery templates
that members of your team create in their workbench and then export.
The XML file that contains the exported SQL and XQuery templates has
the following syntax. If the file contains more than one template,
each template is represented by one
<template> element.
<?xml version="1.0" encoding="UTF-8"?>
<templates>
<template autoinsert="false" context="sql" deleted="false"
description="your_template_description" enabled="true"
name="your_template_name">your_template_pattern</template>
</templates>
The value for the
autoinsert attribute
can be
true or
false. The value
for the
context attribute is
sql or
xquery,
depending on the type of template that was exported.
Procedure
To import
an SQL or XQuery template:
- Select .
- In the Preferences window, select .
- On the Templates page, click Import,
and then browse to and select the file that contains the template
that you want to import. The template in the imported template
file is added to the list of templates on the SQL and XQuery Editor - Templates
page
- Click OK in the Preferences window.
Results
The imported template is available in your workbench for you
to use in the SQL and XQuery editor.