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
.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.
- 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 current page data
It is recommended to export all results instead of exporting the current page.
Follow the steps below to export the current page:
- Select the Result tab.
- Click
to export the current page.The Data Studio Security Disclaimer dialog box is displayed.
- Click OK.
- Select the location to save the current page.
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.
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.