Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
nand rai
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic