SQL> SELECT * FROM AA;
TERM MY_TYPEMY_DATA
---------- -
----------
1 A
10
1 B 5
1 C
20
2 A
34
2 D 9
2 E
17
3 A 6
SQL> select term,
sum(decode(my_type,'A',my_data,0)) A,
sum(decode(my_type,'B',my_data,0)) B,
sum(decode(my_type,'C',my_data,0)) C,
sum(decode(my_type,'D',my_data,0)) D,
sum(decode(my_type,'E',my_data,0)) E
from aa group by term;
TERM
A
B
C
D
E
---------- ---------- ---------- ---------- ---------- ----------
1 10
5 20
0
0
2 34
0
0
9 17
3
6
0
0
0
0
|