求:每个部门对应的员工姓名(将同一部门所有员工姓名合并到一条记录)
select deptno, max(enames) enames
from (select deptno, substr(sys_connect_by_path(ename, ','), 2) enames
from (select deptno,
ename,
row_number() over(partition by deptno order by ename) rowno
from emp)
connect by rowno = prior rowno + 1
and deptno = prior deptno
start with rowno = 1)
group by deptno