Re: How write results of Select into sequential file?

From: <joseph_testa_at_aep.com>
Date: Wed, 13 May 1998 18:36:29 GMT
Message-ID: <6jcp7e$t2u$1@nnrp1.dejanews.com>

You have a couple of choices, 1. using utl_file package to write out a flat file on the db server, 2. check out my web page, there is a script(not written by me), that will write out a file of info from a table that can be used as input to sql*loader.

hth, joe
http://www.oracle-dba.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 ???
>
> TIA,
>
> Rog
>
> --
> roger@_delete_this_to_reply_.martech.com
>
>

-----== 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 - 13:36:29 CDT