Exporting a query or query results

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:
  1. Right-click the query in the Navigator view and click Export Query or Export Records, as appropriate.
  2. 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.