--用于普通组函数
select deptno,wm_concat(ename) enames
from emp
group by deptno
order by deptno;
DEPTNO
ENAMES
10 CLARK
10 CLARK,KING,KING,KING
10 CLARK,KING,KING,KING
10 CLARK,KING,KING,KING
10 CLARK,KING,KING,KING,MILLER
20 ADAMS
20 ADAMS,FORD
20 ADAMS,FORD,JONES
20 ADAMS,FORD,JONES,SCOTT
20 ADAMS,FORD,JONES,SCOTT,SMITH
30 ALLEN
30 ALLEN,BLAKE
30 ALLEN,BLAKE,JAMES
30 ALLEN,BLAKE,JAMES,MARTIN
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD
--用于分析函数
select deptno,wm_concat(ename)
over(partition by deptno order by ename)
from emp
DEPTNO
ENAMES
10 CLARK
10 CLARK,KING,KING,KING
10 CLARK,KING,KING,KING
10 CLARK,KING,KING,KING
10 CLARK,KING,KING,KING,MILLER
20 ADAMS
20 ADAMS,FORD
20 ADAMS,FORD,JONES
20 ADAMS,FORD,JONES,SCOTT
20 ADAMS,FORD,JONES,SCOTT,SMITH
30 ALLEN
30 ALLEN,BLAKE
30 ALLEN,BLAKE,JAMES
30 ALLEN,BLAKE,JAMES,MARTIN
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD