In this short tutorial, I’ll show you a quick way to export query results to CSV in Oracle SQL Developer.
I’ll use a simple example to demonstrate the steps to export your query results.
Steps to export query results to CSV in Oracle 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. For illustration purposes, I created a simple query that would generate the following results:
Step 2: Open the Export Wizard
After you ran the query, you would 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 would then see the Export Wizard as follows:
Step 3: Select the CSV format and the location to export your file
Now you’ll need to:
(1) Select the CSV format from the drop-down list
(2) Click on the ‘Browse…’ button to select the location where the CSV file will be saved
(3) Press on the ‘Next >’ button once you are done
Step 4: Export query results to CSV
For the final step, click on the ‘Finish’ button to export the query results to CSV in SQL Developer:
That’s it! This was just one way to export query results to CSV in Oracle SQL Developer. You can use other methods in SQL Developer, such as the Spool method, to accomplish the same goal.
We used a simple query to demonstrate this concept, but the same principles would apply if you’re using any other queries in SQL Developer.