When you are working with an SQL script in the SQL and
XQuery editor, you can export one or more of the SQL statements in
the script.
Before you begin
The script that contains the SQL statements that you want
to export must be open in the SQL and XQuery editor.
About this task
You can export all the SQL statements in the script or
you can export only the statements that you select. The exported SQL
statements are saved in a text-based file that, by default, has the
same name as the SQL script, including the extension .sql.
Procedure
To export SQL statements from a script in the SQL and
XQuery editor:
- If you want to export only some of the SQL statements in
the script, select one or more of the statements. The editor
does not validate your selection for completeness.
- In the top border of the editor, click Export.
- In the Export to Directory window,
browse to the appropriate directory and then, optionally, specify
the name of the file to contain the exported SQL statements.
Results
The file that is created contains the SQL statements that
you exported. If you make changes in the SQL and XQuery editor to
SQL statements that you exported, the statements in the exported file
are not updated with those changes.