Exporting Query Results

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 .

   The Export ResultSet Data window is displayed.

   Refer to Exporting Table Data to complete the export operation.

   

   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.
   

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

   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.
   

   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.