- 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.
- Now Select all your data by highlighting it.
- Right click on your selection and select Export Data and finally choose a file format.
- Give your file a name and location and confirm the export operation.
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:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment