Home > IT Answers > Oracle > how to transfer oracle table data to .csv file by using pl/sql coding
Tarick21
5 pts.
 how to transfer oracle table data to .csv file by using pl/sql coding
.CSV files, Oracle, Oracle Table
how to transfer oracle table data to .csv file by using pl/sql coding

Software/Hardware used:
ASKED: March 14, 2012  7:14 AM
UPDATED: March 14, 2012  3:11 PM
RELATED QUESTIONS
Answer Wiki:
You would have to create a cursor to read the data you want to export, and use the <a href="http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/u_file.htm">UTL_FILE package</a> to create the file and write the data to it. Here is another link with useful information and some examples: <a href="http://docstore.mik.ua/orelly/oracle/bipack/ch06_02.htm">UTL_FILE: Reading and Writing Server-side Files</a>
Last Wiki Answer Submitted:  March 14, 2012  3:11 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _