Export Query Results to CSV in SQL Developer

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:

  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 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.

Leave a Comment