日期:2014-05-16  浏览次数:20445 次

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
??