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.
Procedure
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.