In this short guide, you’ll see a quick way to export query results to CSV in SQL Developer.
Steps to export query results to CSV in SQL Developer
Step 1: Run your query
Firstly, you’ll need to run your query in SQL Developer. You can choose any query based on your needs.
Step 2: Open the Export Wizard
After you ran the query, you’ll see the query results at the bottom section of your SQL Developer.
Right-click on any cell on the query results, and then select the ‘Export…‘ option from the drop down menu.
You’ll then see the Export Wizard.
Step 3: Select the CSV format and the location to export your file
Now you’ll need to:
- Select the CSV format from the drop-down list
- Click on the ‘Browse…‘ button to select the location where the CSV file will be saved
- Press on the ‘Next >‘ button once you are done
Step 4: Export the query results to CSV
For the final step, click on the ‘Finish‘ button to export the query results to CSV in SQL Developer.
Conclusion
The method described in this guide is just one way to export your query results to a CSV file. You can use other approaches in SQL Developer, such as Spool, to accomplish the same goal.
You may also want to check the following guide that explains the steps to export query results to Excel in Oracle SQL Developer.