select dept.dname,wm_concat(emp.ename) from dept,emp where dept.deptno=emp.deptno group by dept.dname 原文链接：https://www.f2er.com/oracle/210842.html
select dept.dname,wm_concat(emp.ename) from dept,emp where dept.deptno=emp.deptno group by dept.dname 原文链接：https://www.f2er.com/oracle/210842.html