load data into flat file

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
venkat_mel
Posts: 22
Joined: Wed Feb 14, 2007 5:50 pm
Location: Australia

load data into flat file

Post 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
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

Post 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.
Anvesh reddy
Posts: 4
Joined: Sun Sep 21, 2008 2:56 pm
Location: USA

Post by Anvesh reddy »

yes u can make use of UTL_FILE built in package
icahyd
Posts: 2
Joined: Mon Nov 10, 2008 5:04 pm
Location: India

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest