Win a copy of Functional Reactive Programming this week in the Other Languages 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
  • 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: 34973
379
Eclipse IDE Java VI Editor
  • 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
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic