这样的oracle sql语句如何来写，高手请进

原来  
SELECT "dept"."DEPT_CODE",   
         sum(decode("dept"."ITEM_NAME",'部门1',round(24*("dept"."END_DATE" - "dept"."START_DATE"),2),0)) '部门1' ,   
         sum(decode("dept"."ITEM_NAME",'部门2',round(24*("dept"."END_DATE" - "dept"."START_DATE"),2),0)) '部门2',
  sum(decode("dept"."ITEM_NAME",'部门3',round(24*("dept"."END_DATE" - "dept"."START_DATE"),2),0)) '部门3' ,
         sum(decode("dept"."ITEM_NAME",'部门4',round(24*("dept"."END_DATE" - "dept"."START_DATE"),2),0)) '部门4' ,
         sum(decode("dept"."ITEM_NAME",'部门5',round(24*("dept"."END_DATE" - "dept"."START_DATE"),2),0)) '部门5' ,
         sum(decode("dept"."ITEM_NAME",'部门6',1,0))'部门6'
    FROM "dept"  GROUP BY "dept"."DEPT_CODE"
            
现在"dept"."ITEM_NAME"的内容是变化的，但是唯一的，我想根据变化的内容，完成上述的功能，用一条SQL语句，请高手帮忙