File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Gettng data from Oracle DB and writing row-wise values to seperate csv files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Gettng data from Oracle DB and writing row-wise values to seperate csv files" Watch "Gettng data from Oracle DB and writing row-wise values to seperate csv files" New topic
Author

Gettng data from Oracle DB and writing row-wise values to seperate csv files

Ankit Bhalerao
Greenhorn

Joined: Jul 23, 2008
Posts: 1
Hi
I am new to java... need some help.
I need to pick up data from an Oracle 10g DB Table, and then store these values in CSV format at a specified directory location. How should I proceed?
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36478
    
  16
You can probably get most databases to "dump" csv files.
Failing which you can iterate through the rows in a ResultSet and print them to text files.
I presume you are familiar with the use of JDBC; if not, read this.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36478
    
  16
. . . and welcome to JavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Gettng data from Oracle DB and writing row-wise values to seperate csv files
 
Similar Threads
field mapping
read large CSV file and update the database
populate data from csv into oracle
Sample Data for Tables in Oracle 10g XE
Searching and Updating a CSV file