pl/sql for calculating min, max, avg....
Hi,
I looking for a program that can calculate the min, max,avg, unique, null and so on and in addition calculate the values in histogram type...
for example: if i have a table t1 with columns c1, c2, c3
and if c1 has values like: 2, 7, 15, 24, 29, 38
i want it to calculate the values like
c1:
1-10: 2
11-20: 1
21-30: 2
31-40: 1
like histogram. in addition, if i can invoke something to have it like a html output with some nice graphs that will be awesome.
i guess the min, max and stuff can be gotten from the system tables after analyze.
please advice.
ks