请问各位大神以下oracle plsql语句怎么写答:sum(decode(a.hpdm,302,a.je))物品B,sum(decode(a.hpdm,303,a.je))物品C,sum(decode(a.hpdm,304,a.je))物品D,sum(decode(a.hpdm,305,a.je))物品E,from ckhp a group by a.ckdm)t where t.ckdm = c.ckdm group by ckmc order by c.ckdm;没有实际建表,你试下是否可行。