Simply run the following query :
show parameter service_name;
Showing posts with label SQL Developer. Show all posts
Showing posts with label SQL Developer. Show all posts
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:
- 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.
Subscribe to:
Posts (Atom)