Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create a graph from Oracle queries
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
![]() |
![]() |