oracle 行列转换 WMSYS.WM_CONCAT
select t.rank, t.Name from t_menu_item t;
????10 CLARK
????10 KING
????10 MILLER
????20 ADAMS
????20 FORD
????20 JONES
????20 SCOTT
????20 SMITH
????30 ALLEN
????30 BLAKE
????30 JAMES
????30 MARTIN
????30 TURNER
????30 WARD
--------------------------------
我们通过 10g 所提供的 WMSYS.WM_CONCAT?函数即可以完成 行转列的效果
????select t.rank, WMSYS.WM_CONCAT(t.Name)?TIME From t_menu_item t GROUP BY t.rank;
DEPTNO ENAME
------ ----------
????10 CLARK, KING, MILLER
????20 ADAMS, FORD, JONES, SCOTT, SMITH
????30 ALLEN, BLAKE, JAMES, MARTIN, TURNER, WARD
?
?
http://blog.csdn.net/tianlesoftware/article/details/4704858
