SELECT LISTAGG(GOODSNAME,‘;‘) WITHIN GROUP (ORDER BY GOODSNAME) AS sd FROM DIM_ERP_PUB_GOODS WHERE ROWNUM<4
WM_CONCAT() 方法被替代成：LISTAGG(GOODSNAME,‘;‘) WITHIN GROUP (ORDER BY GOODSNAME) AS sd
Oracle 多行拼接函数 :[Err] ORA-00904: "WM_CONCAT": 标识符无效
原文：https://www.cnblogs.com/wuzaipei/p/11905507.html