Exporting SQL Developer results to Excel?
mary-ppa01
-
klmop -
klmop -
Hello
My issue is to export results from SQL Developer to Excel, is it possible?
Thank you very much.
My issue is to export results from SQL Developer to Excel, is it possible?
Thank you very much.
2 answers
-
In Oracle SQL Developer V3:
- Execute the said SQL query.
- Right-click on the data in the grid representing the result of the query.
- Select unload from the dropdown menu.
- A window opens, you choose: the data format (xls, csv, ...), the character encoding.
- The file is saved to this location and under this name by default C:\Users\[your_username]\export.xls