--分组加排序，数据量大时结果会比较慢
SELECT listagg(t.ename,‘,‘) WITHIN GROUP(ORDER BY t.sal) FROM scott.emp t;
查询结果为CLOB
SELECT wm_concat(t.ename) FROM scott.emp t ORDER BY t.sal;
--分组加排序，数据量大时结果会比较慢
SELECT listagg(t.ename,‘,‘) WITHIN GROUP(ORDER BY t.sal) FROM scott.emp t;
查询结果为CLOB
SELECT wm_concat(t.ename) FROM scott.emp t ORDER BY t.sal;
原文：https://www.cnblogs.com/ViokingJava/p/8184899.html