This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to unload the table data to a txt file.

 
aresh babu
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

Please let us know how to unload oracle table data to a normal file..
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not sure what you mean by a normal file. Maybe export the table to csv (comma separated value) ?
 
Badal Chowdhary
Ranch Hand
Posts: 34
Eclipse IDE Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it is a one time process, then you could export the file as Jeanne suggested.

If this would be called frequently, then following are some options:
1) Write a procedure that writes data to a file using utl_file package
2) Write a program (eg using JDBC) that iterates through the resultset and writes data to a file using BufferedWriter.

Thanks,
Badal
 
aresh babu
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jeanne ,

i want to load into in a CSV or .txt file.

Please let me know how can i load the data from a table to CSV file without using java(jdbc,hibernate)..

Thanks & Regards
Aresh babu
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic