Re: making graphical reports from oracle metrics

On Mon, Dec 1, 2008 at 3:44 AM, Prem Khanna J <jpremhere_at_yahoo.co.in> wrote:

> Hi Nuno , we have been doing that copy/paste to excel manually so long
> .....
> It is painful and takes time .... so we would like to automate it as far as
> possible ....
>

Copy/Paste isn't really necessary.

At the very least you can easily use sqlplus to dump data to CSV files, which can be opened directly in excel.

You can also use Perl with the DBI, DBD::Oracle and Spreadsheet::WriteExcel modules, and create excel spreadsheets directly from data.

There's also a PL/SQL module (commercial, google for it) that can be used to directly create Excel files.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l