decode函数

select /*+ PARALLEL(t, 16) */curr_deal,
sum(decode(dr_type,'103',sheet_cnt,0))  sheet103  ,
sum(decode(dr_type,'104',sheet_cnt,0))  sheet104  ,
sum(decode(dr_type,'204',sheet_cnt,0))  sheet204  ,
sum(decode(dr_type,'1102',sheet_cnt,0)) sheet1102 ,
sum(decode(dr_type,'1103',sheet_cnt,0)) sheet1103 ,
sum(decode(dr_type,'1104',sheet_cnt,0)) sheet1104 ,
sum(decode(dr_type,'1122',sheet_cnt,0)) sheet1122 ,
sum(decode(dr_type,'1123',sheet_cnt,0)) sheet1123 ,
sum(decode(dr_type,'1124',sheet_cnt,0)) sheet1124 ,
sum(decode(dr_type,'8001',sheet_cnt,0)) sheet8001 ,
sum(decode(dr_type,'8003',sheet_cnt,0)) sheet8003 ,
sum(decode(dr_type,'8007',sheet_cnt,0)) sheet8007 ,
sum(decode(dr_type,'8011',sheet_cnt,0)) sheet8011 ,
sum(decode(dr_type,'60101',sheet_cnt,0))sheet60101,
sum(decode(dr_type,'