For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
SELECT RTRIM(XMLAGG(XMLELEMENT(E,user_login,',').EXTRACT('//text()') ORDER BY user_login).GetClobVal(),',') AS LIST FROM USER where rownum <=1000;
like: 'user1','user2','user3'