I want to load the data from oracle database to a flat file
nand rai
Greenhorn
Joined: Feb 17, 2009
Posts: 27
posted
0
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
posted
0
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.
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
posted
0
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.
0
