Page 1 of 1
load data into flat file
Posted: Sun Jul 22, 2007 7:25 pm
by venkat_mel
hi,
how to Write a PL/SQL program to extract data from Oracle base tables into a flat file. can i use UTL_FILE or is there any other way.
thanks,
venkat
Posted: Tue Jul 24, 2007 2:39 am
by siva sankar
Hi Venkat,
You Can extract the data from base tables to flat file by using UTL_FILE package,This is Called OUTBOUND Interface.
Posted: Tue Dec 02, 2008 1:03 am
by Anvesh reddy
yes u can make use of UTL_FILE built in package
Posted: Tue Feb 24, 2009 5:29 pm
by icahyd
hi,
how to Write a PL/SQL program to extract data from Oracle base tables into a flat file. can i use UTL_FILE or is there any other way.
thanks,
venkat
<i><div align="right">Originally posted by venkat_mel - Jul 22 2007 : 3:25:18 PM</div id="right"></i>
I am using Data Loader an excellent tool to convert tables into flat files and much more you can download a free edition
www.dbload.com
Ashi