我的方法错在那里请问？（100分)

Question

create or replace new_view as
select object_name,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/01',一月V1,0))一月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/02',二月V1,0))二月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/03',三月V1,0))三月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/04',四月V1,0))四月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/05',五月V1,0))五月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/06',六月V1,0))六月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/07',七月V1,0))七月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/08',八月V1,0))八月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/09',九月V1,0))九月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/10',十月V1,0))十月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/11',十一月V1,0))十一月出,
 sum( decode(to_char(TIME,'yyyy/mm'),'2004/12',十二月V1,0))十二月出
 from old_view group by object_name

Answer 1

分组求和,.但是要求你的V1,V2是数字型的.否则不好这么做.