Re: print a log

On Sun, 22 Nov 1998 12:07:03 +0100, "bleueye" <bleueye_at_hotmail.com> wrote:

>Hi oracle people,
>
>Can somebody explain me how to print a file in sql code.
>
>For excample: when i made some changes to the database there's made a report
>and i want to print that report when it's finished.
>
>Thanks,
>
>E.J. Smit
>(e.smit_at_caiw.nl)

In a windows environment you could execute the following from within a SQLPlus session:

Spool c:\temp\filelist.lis
select * from <filename>;
spool off;

This will create a file called filelist.lis in your c:\temp folder that contains the output of anything executed within your SQLPLUS session.

-Paul
>
Received on Thu Nov 26 1998 - 05:46:39 CET