Re: oracle output to excel

From: Bart the bear <bartthebear_at_gmail.com>
Date: 2 Feb 2006 07:56:49 -0800
Message-ID: <1138895809.579801.252920@f14g2000cwb.googlegroups.com>

Murtuja wrote:
> I want daily report in Excel format.and this excel file should be
> mailed to client.I want autoamtic process for that just like cron job.
>
> I am using Oracle 9i on Linux

I believe that a good combination of DBI, DBD::Oracle and Spreadsheet::WriteExcel or
Spreadsheet::SimpleExcel is what you are looking for. If you want to send it all by email,
you can use MIME::Lite. These modules are available from CPAN, Comprehensive Python
Archive Network. Received on Thu Feb 02 2006 - 09:56:49 CST