这是最基础的用法: LISTAGG(XXX,XXX) WITHIN GROUP( ORDER BY XXX)
例:
select listagg(oeid,‘,‘) within GROUP (order by oeid)
Oracle 列转行函数 Listagg()
原文:http://www.cnblogs.com/yuany69/p/6092877.html