Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP w/ PL/SQL writing to a flat file.

Re: HELP w/ PL/SQL writing to a flat file.

From: Peter Schneider <pschneider.ctj_at_metronet.de>
Date: 1997/11/13
Message-ID: <346b7a14.3495595@pop-news.metronet.de>#1/1

On 12 Nov 1997 23:42:07 GMT, cybersaurn_at_aol.com (CyberSaurn) wrote:

[SNIP]
>On the flip side it is A LOT of data -- millions of rows to be processed --
> very long record lengths to be output too (and 500,000 records?) But there is
> minimal formatting. Run a query, output tab-delimited columns to flat file,
> run a query, append additional records, run a query.... And we will run batch
> overnight.
>

If you have very long records, then using UTL_FILE will not be an option for you, as it limited to a maximum line length of 1023 bytes when creating a flat file.

Regards,
Peter

Peter Schneider
pschneider.ctj_at_metronet.de Received on Thu Nov 13 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US