wood burning stoves 2.0*
The moose likes JDBC and the fly likes I want to load the data from oracle database to a flat file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "I want to load the data from oracle database to a flat file" Watch "I want to load the data from oracle database to a flat file" New topic
Author

I want to load the data from oracle database to a flat file

nand rai
Greenhorn

Joined: Feb 17, 2009
Posts: 27
I want to load the data from many oracle tables to many flat files with comma delimiter,what is the best approach. Does any one have sample code to share with me.
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
A self-respected RDBMS ships with export tools for CSV files. Consult its documentation for details. There is no need to do so with JDBC.
nand rai
Greenhorn

Joined: Feb 17, 2009
Posts: 27
Bauke Scholtz wrote:A self-respected RDBMS ships with export tools for CSV files. Consult its documentation for details. There is no need to do so with JDBC.


I want to automate this instead of manual process. and also my database has some BLOBS i have recrete the original files and save them separately
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
Well, there are Java API's out to handle CSV files. Google "java csv api" or something straightforward like that to get the libraries listed.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I want to load the data from oracle database to a flat file
 
Similar Threads
pdf gen using xsql
Flat file from Oracle DB
how to access MSAccess and Oracle in one query
help needed
scenario