pl/sql for calculating min, max, avg....

[kshathrya]

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

[marist89]

tahiti.oracle.com under "basic understanding of SQL"

[hux]

>>in addition, if i can invoke something to have it like a html output with some nice graphs that will be awesome.

I would recommend looking into Crystal reports or some equivalent, it will greatly simplify yer task.

[tamilselvan]

For Frequency chart, a simple SQL can do.
Ex:
14:26:21 H8DEVW3>SELECT * FROM T1 ;

C1
----------
10
33
22
24
35
2
7
8
38

9 rows selected.

select DECODE(FREQ,10,'1-10',20,'11-20',30,'21-30',40,'31-40') INT,
COUNT(*)
from (select ( case
when (c1 between 1 and 10 ) then 10
when (c1 between 11 and 20 ) then 20
when (c1 between 21 and 30 ) then 30
when (c1 between 31 and 40 ) then 40
else 0
end ) FREQ
from t1)
GROUP BY DECODE(FREQ,10,'1-10',20,'11-20',30,'21-30',40,'31-40')
/

INT COUNT(*)
----- ----------
1-10 4
21-30 2
31-40 3


Tamil

[stecal]

Same question posted at dbaclick.com and ks was told to read the documentation. Did not, so sk came here. And how is this related to certification?