ORA-00932:数据类型不一致,应为-,但却为CLOBrom
本地不报错,服务器上报错
目标:一行写查出来的多列值,值用逗号隔开,如图:
源代码:(用wm_concat)
select wm_concat(a.id), wm_concat(name) from
tablename a GROUP BY a.id
修改后:(用listaggt)
select distinct(a.id),
listagg (a.name, ‘,’) WITHIN GROUP (ORDER BY a.name) over(PARTITION BY a.id)
from tablename a