Learn how to export data from Oracle SQL developer to Excel.
Follow These Steps to Export Data from Oracle SQL Developer to Excel
- In the connection navigator, expand the Table node and select the table for which you want to export the data.
- Right click on the selected table and choose the Export option from the drop-down menu. Then Export Wizard window will open (as shown in Figure 2.1).
- In the Export Wizard window, uncheck the Export DDL option if you don't want to export the DDL script for the table.
- In the Export Data section, select the Format Excel 2003+ (xlsx) from the drop-down menu.
- In the Data Worksheet Name, give the name for the worksheet (this is optional).
- In the File section, specify the file location and name, you can use the Browse button.
- Then click on the Next button and step second will appear.
- In this step, you can choose whether all columns or click on the pencil icon to choose specific columns.
- Click on Next button and in the third step, it will show you the export summary.
- Click on the Finish button and your data will be exported to the specified location.
Note:
To export Data From SQL query results in Oracle SQL Developer, just right click on the query result and choose the Export option and follow the steps from 4 to 6.
Version Used
Oracle SQL Developer 18.1