Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to unload the table data to a txt file.  RSS feed

 
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
Sheriff
Posts: 36396
453
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
Boost this thread!