You can export a query or query results to the file system. Exporting
a query is useful for transferring queries from one database to another and
for sharing queries amongst colleagues. You can use exported query results
as input to other applications.
Before you begin
To transfer a query from one database to another, both databases must
use the same schema.
About this task
To export a query or query results to the file system:
- Right-click the query in the Navigator view and
click Export Query or Export Records,
as appropriate.
- In the Export Query window, navigate to the location in which to
save the export file. You can rename the file, if desired. Then click Save.