Oracle 撈取資料後，如何進行倒置 (轉置) 正常來說，下了以下的語法會變成下圖
select '1' a from dual union select '2' a from dual union select '3' a from dual union select '4' a from dual union select '5' a from dual
若因抓出的資料需要並列於1列中，該如何轉置?
只要使用wmsys.wm_concat便行了
select wmsys.wm_concat(a) from ( select '1' a from dual union select '2' a from dual union select '3' a from dual union select '4' a from dual union select '5' a from dual);
文章標籤
全站熱搜
留言列表
