oracle 学习笔记

SQL> --行转列SQL> -- wm_concat(varchar2) 组函数SQL> col nameslist for a60SQL> 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