Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: create a graph from Oracle queries

Re: create a graph from Oracle queries

From: Gary Gapinski <glg_at_apk.net>
Date: Wed, 17 Oct 2001 06:05:07 -0400
Message-ID: <3BCD57D3.2C0F8524@apk.net>


See Ptolemy II Ptplot at
http://ptolemy.eecs.berkeley.edu/java/ptplot5.1p1/ptolemy/plot/doc/

Soojin Kim wrote:
>
> Hi!
> I am wondering whether there are any scripts or tools available to
> create a graph from Oracle queries.
> For example, I would like to collect all the values from
> "select to_char(trunc(first_time, 'HH24'),'DY DD-MON-YY HH24:MI')
> "HOUR", count(*) "LOG COUNT"
> from v$loghist
> group by trunc(first_time, 'HH24')
> order by trunc(first_time, 'HH24');"
> and generate a graph.
> I am willing to try Oracle + Perl or OAS .......
> If any of you have come across any thing to do that please let me
> know.
>
> Thanks in advance.
> soojin kim
Received on Wed Oct 17 2001 - 05:05:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US