Forums Register Login

Export Query to Excel for ORACLE

+Pie Number of slices to send: Send
Hi,
I would like to Export the result of sql query into Excel.
regards
sudha
[ September 18, 2007: Message edited by: sudha swami ]
+Pie Number of slices to send: Send
A lot of GUI applications will allow you to cut and paste data into Excel but from a programmatic standpoint, its best to write a java program that converts the result set into a CSV file (just fields separated by commas) and import that into excel.

You could also try GUI tools for exporting your database directly into a CSV file.
+Pie Number of slices to send: Send
See if the POI Library does what you need. I've only used it to read excel but it worked easily enough.
+Pie Number of slices to send: Send
Hi,
Thanks alot for the info. Currently i am using GUI Tool, DBVisualizer and it supports exporting the data into CSV
sudha
when your children are suffering from your punishment, tell your them it will help them write good poetry when they are older. Like this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1979 times.
Similar Threads
how to export data to Excel
JasperReports -- excel issue
Export to excel
Export functionality
Upload Excel Data in oracle Database
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 05:17:49.