Oracle怎样将可变列转为行？？

方法1：decode --用decode实现行转列--适用范围：8i,9i,10g及以后版本SELECT NO,SUM(decode(CODE, '010', COST)) "010",SUM(decode(CODE, '011', COST)) "011",SUM(decode(CODE, '019', COST)) "019",SUM(decode(CODE, '047', CO