Use this command 🙂

select rtrim (xmlagg (xmlelement (e, empno|| ',')).extract ('//text()'), ',') enames

from emp

By

Nitesh Jyotirmay