Exporting Query Results

You can export the results of an SQL query into a CSV, Text or Binary file.

This section contains the following topics:

Exporting all data

The following functions are disabled while the export operation is in progress:

  • Executing SQL queries in the SQL Terminal

  • Executing PL/SQL statements

  • Debugging PL/SQL statements

Follow the steps below to export all results:

  1. Select the Result tab.

  2. Click image1.

    The Export ResultSet Data window is displayed.

    Refer to Exporting Table Data to complete the export operation.

    Note

    You can check the status bar to view the status of the result being exported.

    The Data Exported Successfully dialog box is displayed.

  3. Click OK. Data Studio displays the status of the operation in the Messages tab.

    Note

    If the disk is full while exporting the results, then Data Studio displays an error in the Messages tab. In this case, clear the disk, re-establish the connection and export the result data.

The Messages tab shows the Execution Time, Total Result Records Fetched, and the path where the file is saved.

Exporting Data On the Current Page

It is recommended to export all results instead of exporting the current page. The Export Current Page to CSV function has been deleted.

Follow the steps below to export the current page:

  1. Select the Result tab.

  2. Click the image2 icon to export the current page.

    The Data Studio Security Disclaimer dialog box is displayed.

  3. Click OK.

  4. Select the location to save the current page.

    Note

    You can check the status bar to view the status of the page being exported.

  5. Click Save. The Data Exported Successfully dialog box is displayed.

  6. Click OK. Data Studio displays the status of the operation in the Messages tab.

    Note

    If the disk is full while exporting the results, then Data Studio displays an error in the Messages tab. In this case, clear the disk, re-establish the connection and export the result data.