Thanks for the question, Riyaz.
Asked: May 22, 2012 - 1:09 am UTC
Last updated: May 22, 2012 - 10:13 am UTC
Version: 10G
Viewed 1000+ times
You Asked
To extract the data from database to CSV file, I have used the following methods.
1- UTL_FILE
2- Simple SELECT and spool it into text file.
Both the method has pros and cons. When we use UTL_FILE, it can not be extracted into client machine and when SELECT/spool is used it can not be made as the full-fledged script.
Is there any other best method available in oracle or can the above methods efficiently used to do this task.
and Tom said...
... when SELECT/spool is used it can not be made as the full-fledged script. ...
what do you mean by that?
Here are the techniques I've used:
http://asktom.oracle.com/Misc/httpasktomoraclecomtkyteflat.html that does sqlplus (fully scripted - complete control), utl_file and a pro*c program.
Also, APEX - Application Express, which comes with every Oracle database - has tool for this as well.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment