查询结果为CLOB
SELECT wm_concat(t.ename) FROM scott.emp t ORDER BY t.sal;
Oracle同一字段用逗号分隔(列转行)
标签：查询 -- gpo acl listagg agg scott 数据 class
Oracle同一字段用逗号分隔(列转行)
listagg(t.ename,‘,‘) WITHIN GROUP(ORDER BY t.sal) FROM scott.emp t;