Re: How to use PL/SQL to extract records from table to a file

Sybrand Bakker wrote:

> Either use spool in conjunction with dbms_output or utl_file.
> For the rest, you should really refer to the Pl/sql manual or (maybe) to the
> pl/sql tutorials at revealnet.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Maggie" <maggiezhou_at_hotmail.com> wrote in message
> news:8sfdq7$t81$1_at_web1.cup.hp.com...
> > I am trying to write a PL/SQL procedure in order to extract records to
> > output file.
> > I don't know in PL/SQL which methods I can use to implement it.
> > Please help.
> >
> > Thanks.
> >
> >

I would also add that DBMS_PIPE with a separate listener process would also be a good choice and would overcome some problems that are inherent with DBMS_OUTPUT - especially if the amount of data is not trivial. It does take more coding but will probably have greater stability in the long run if used for production purposes. Received on Mon Oct 16 2000 - 15:24:57 CDT