joe17836_at_my-deja.com wrote:
>
> In article <38612989.564775CF_at_Unforgettable.com>,
> Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote:
> > joe17836_at_my-deja.com wrote:
> > >
> > > Is there any way to write data to a flat file from an Oracle
> database
> > > besides using "spool" or the utl_file package in PL/SQL? Anyone
> know
> > > why Oracle doesn't provide a utility like SQLLoader (SQL UN-Loader?)
> > > for writing to flat files? Both "spool" and utl_file seem pretty
> slow.
> > >
> > > Thanks!
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> > Write your own Pro-C program.
> >
> Would that be any faster than PL/SQL?
>
Yes. Especially if you use write() instead of printf() and if you are
judicious in your use of joins.
If you want to speed up pl/sql you might want to think about sending the
output to dbms_pipe and then have a listener running to actually send the
data to a file. That way your pl/sql doesn't have to wait for i/o.
Received on Thu Dec 23 1999 - 12:18:17 CST
