SELECT deptno, LISTAGG(ename, ',' ON OVERFLOW TRUNCATE '~~~' WITHOUT COUNT) WITHIN GROUP (ORDER BY ename) Hope it helps! Why not use WM_CONCAT function in Oracle? 29 Wednesday Apr 2015 Posted by Lalit Kumar B in Oracle 12c Installation & New Features ≈ 3 Comments Tags 12c, orac...
however,STRING_AGG()finally answered long-standing and widespread pleas from the community to simulateGROUP_CONCAT()and similar functionality found in other platforms. I recently started modifyingmany of