Re: create a graph from Oracle queries

In <988022a0.0110142349.7098e861_at_posting.google.com> soojin_kim52_at_hotmail.com (Soojin Kim) writes:

>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.

Personaly, I do it in perl. You need PerlTk, and The DBI, + the Oracle DBD.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin