How to export query results from Oracle SQL Developer tool

So you ran a query in Oracle SQL Developer and it returned many rows. You would like to take this data and export it to a excel , CSV,  PDF or HTML file for further processing and easier navigation. You can achieve this by following these steps:


  1. SQL Developer usually return a limited number of rows, to get all rows go to the last returned row and press Ctrl + End. This will fetch all rows.
  2. Now Select all your data by highlighting it.
  3. Right click on your selection and select Export Data and finally choose a file format.
  4. Give your file a name and location and confirm the export operation.


No comments:

Post a Comment