Re: making graphical reports from oracle metrics

From: Jared Still <>
Date: Mon, 1 Dec 2008 08:24:37 -0800
Message-ID: <>

On Mon, Dec 1, 2008 at 3:44 AM, Prem Khanna J <> 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

Received on Mon Dec 01 2008 - 10:24:37 CST

Original text of this message