Re: How write results of Select into sequential file?

From: <hparks_at_mlock.com>
Date: Wed, 13 May 1998 14:52:34 GMT
Message-ID: <6jcc3j$2f8$1@nnrp1.dejanews.com>

In article <6jatvo$moc$1_at_news1.rmi.net>, "Roger Loeb" <rloeb_at_martech.com> wrote:
>
> So, I know how to load a table from a file with fixed length records (using
> SQLLDR), but how do I write such a file. I need to extract specific fields
> from a table, concatenate them together to form a "record," append a
> linefeed, and write the records to a sequential file. There are about 50
> million 180-byte records involved in this process.
>
> I know how to do it using C and OCI, but I'm curious if there's a way to do
> it directly in Oracle with SQL and ???

The UTL_FILE package is designed for this purpose. I can't give any advice on it because I can't get it to work, myself.

We create a table whose only field is varchar2(132). We insert the records into these fields, and use the SQL*Plus SPOOL command to store the records into a file.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 13 1998 - 09:52:34 CDT