- 行轉列
pivot
示例1:
with
tmp_data
as(
select '趙' surname, '15' qty from dual
union all
select '錢' surname, '16' qty from dual
union all
select '孫' surname, '17' qty from dual
)
select *
from tmp_data
pivot(sum(qty) for surname in ('趙' 趙, '錢' 錢, '孫' 孫))
示例2:
with
tmp_data
as(
select '趙' surname, '15' qty from dual
union all
select '錢' surname, '16' qty from dual
union all
select '孫' surname, '17' qty from dual
)
select *
from tmp_data
pivot xml(sum(qty) for surname in (any))
這個結果,很是感人!
所以,接下來要考慮的是,如何將xml轉換成table了。也搜了一下其他人的想法,似乎轉換的時候只能通過存儲過程,但是,我不想這個樣子。
……
試了一天,貌似都不太行啊