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:
Select the Result tab.
Click .
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.
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:
Select the Result tab.
Click the icon to export the current page.
The Data Studio Security Disclaimer dialog box is displayed.
Click OK.
Select the location to save the current page.
Note
You can check the status bar to view the status of the page being exported.
Click Save. The Data Exported Successfully dialog box is displayed.
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.