select * from (select pro_id, sum(decode(month, '01', summ)) one,
sum(decode(month, '02', summ)) two,
sum(decode(month, '03', summ)) three,
sum(decode(month, '04', summ)) four,
sum(decode(month, '05', summ)) five,
sum(decode(month, '06', summ)) six,
sum(decode(month, '07', summ)) seven,
sum(decode(month, '08', summ)) eight,
sum(decode(month, '09', summ)) nine,
sum(decode(month, '10', summ)) ten,
sum(decode(month, '11', summ)) eleven,
sum(decode(month, '12', summ)) twelve
from (select r.pro_id, to_char(r.rabi_date, 'mm') as month,