Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: What's the best reporting tool for ad-hoc and custom-made reporting
Dino Hsu wrote:
>
> Dear all,
>
> We are using Oracle 8.0.5 for Windows NT. I know SQL*Plus and a little bit
> PL/SQL, for ad-hoc reporting, I can write a script something like this:
>
> set pagesize 10000;
> spool listdate;
> select to_char(invoice_date,'yyyymmdd') inv_date,
> to_char(process_date,'yyyymmdd') proc_date,
> count(*) rec_cnt, sum(units) unit_sum from tb_orders
> group by invoice_date, process_date;
> spool off;
> quit;
>
> Furthermore, I need to get the group totals and the grand total, so I import
> his result into Excel or Access for the calculation, which is quite tedious.
> I think I need a good reporting tool for this.
>
> I also found in the case of PL/SQL that Oracle provided tool is not the
> best, maybe 3rd party tool such as SQL Station or TOAD are the best. Can
> anyone commet on the best reporting tool for ad-hos and custom-made
> reporting requirements?
>
> Thanks in advance.
> Dino
One thing you can do is use a stored procedure to put the manipulated data into another table and then create your report from that table. Received on Tue Aug 15 2000 - 07:53:37 CDT