• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Ankit Bhalerao
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 48938
60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 48938
60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
. . . and welcome to JavaRanch
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic