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

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.
>
>
Received on Mon Oct 16 2000 - 13:56:04 CDT