SELECT t1.ename, wm_concat(t2.ename)FROM scott.emp t1, scott.emp t2where t1.empno = t2.mgrgroup by t1.ename;