如何将查询结果的列转换成行显示

[jokylove123]

数据库查询出来的结果 是一行5 列的结果，如何 将这个结果转换为5行2列

[libitum_1]

用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
这样之后：