Re: How write results of Select into sequential file?

From: Dave Macpherson <dave_at_fifthd.ca>
Date: Wed, 13 May 1998 14:08:14 -0600
Message-ID: <6jcug8$v0e$1@news.sas.ab.ca>

Use the UTL_FILE package supplied by Oracle to create a text file and write output lines to the file. It really is a simple procedure and there are examples on how to use it in the Oracle docs.

Dave

Roger Loeb wrote in message <6jatvo$moc$1_at_news1.rmi.net>...
>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
>
>
Received on Wed May 13 1998 - 15:08:14 CDT