Wouldn't the easiest way be to use sqlldr? RBG
----- Original Message -----
From: "Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, January 12, 2001 12:26 PM
Subject: RE: Different ways to transfer data in a table to a FLAT file
> > -----Original Message-----
> > From: Sankaranarayanan, Ramasubramanian
> > [mailto:Ramasubramanian.Sankaranarayanan_at_compaq.com]
> > Sent: vendredi, 12. janvier 2001 07:21
> >
> > Please suggest me a different ways to transfer data from the
> > table to a FLAT
> > file...
>
> The obvious ways:
>
> a) Easiest way - use SQL*Plus select statement, with the appropriate
> SQL*Plus SET commands, to obtain a flat file.
> b) Use a PL/SQL program with the UTL_FILE package.
> c) Use a Pro*C program to read in the data and create a flat file.
>
> I now await the more learned comments of people with greater experience,
who
> will suggest other possibilities.
>
> ------
> any ignorant comments made are the sole responsibility of J. R. Kilchoer
and
> should not reflect adversely upon my employer.
>
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
Received on Fri Jan 12 2001 - 12:01:57 CST
