==注:wm_concat(str1) 11g 后不支持使用==
LISTAGG函数用法
select LISTAGG(name, ',') WITHIN GROUP (ORDER BY id) from tableName
==注:wm_concat(str1) 11g 后不支持使用==
select LISTAGG(name, ',') WITHIN GROUP (ORDER BY id) from tableName
转载于:https://www.cnblogs.com/bradcai/p/11307332.html