Export Query Results to CSV in Oracle SQL Developer

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:

 

Export Query Results in Oracle SQL Developer

 

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:

 

How to Export Query Results in Oracle SQL Developer

 

You would then see the Export Wizard as follows:

 

Export Query Results in Oracle SQL Developer

 

Step 3: Select the CSV format and the export location

Now you’ll need to:

(1) Select the CSV format from the drop-down list

(2) Press the ‘Browse…’ button to select the location where the exported CSV file would be saved

(3) Press the ‘Next >’ button once you are done

 

Export query results to CSV in Oracle SQL Developer

 

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:

 

Export Query Results in Oracle SQL Developer

 

Conclusion

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.