oracle 学习笔记 - wm_concat 函数

SQL> --行转列
SQL> -- wm_concat(varchar2) 组函数

SQL> col nameslist for a60
SQL> select deptno,wm_concat(ename) nameslist
  2  from emp
  3  group by deptno;

    DEPTNO NAMESLIST                                                                                                                                                                                    
--------------------------------------------------------------------------                                                                                                                             
        10 CLARK,KING,MILLER                                                                                                                                                                            
        20 SMITH,FORD,ADAMS,SCOTT,JONES                                                                                                                                                                 
        30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD      

正常显示形式进行对比

SQL> select deptno,ename from emp ;

    DEPTNO ENAME
 --------- --------------
        20 SMITH
        30 ALLEN
        30 WARD
        20 JONES
        30 MARTIN
        30 BLAKE
        10 CLARK
        20 SCOTT
        10 KING
        30 TURNER
        20 ADAMS
        30 JAMES
        20 FORD
        10 MILLER