用unpivot 这个函数
我的表是：
select * from (
select whir$t3639_foreignkey,
       nvl(whir$t3639_f18198, '2017') year,
       monthValue,
       planValue
  from whir$t3639 t
 unpivot(planValue for
               monthValue in (whir$t3639_f17899,
                              whir$t3639_f17900,
                              whir$t3639_f17901,
                              whir$t3639_f17902,
                              whir$t3639_f17903,
                              whir$t3639_f17904,
                              whir$t3639_f17905,
                              whir$t3639_f17906,
                              whir$t3639_f17907,
                              whir$t3639_f17908,
                              whir$t3639_f17909,
                              whir$t3639_f17910))
                              )tt
 where tt.whir$t3639_foreignkey = 4111860
这样之后：