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.
To transfer a query from one database to another, both databases must
use the same schema.
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.