写个SQL语句,在plsql中查询没问题,在java中调用会报如上错误,只是说WM_CONCAT()函数和group by、distinct、union关键字联合使用时,会有这个问题。先记录下解决方案。把wm_concat(字段)换成listagg(字段)within group(order by(字段))
出现问题的代码
SELECT T.*, B.name
FROM A
LEFT JOIN (SELECT T.x,TO_CHAR(WM_CONCAT(T.name)) name
FROM T
GROUP BY x) B
ON A.x= B.x
修改后的代码
SELECT T.*, to_char(B.name)
FROM A
LEFT JOIN (SELECT T.x,
listagg(T.name,',')within group(order by(T.name))T.name
FROM T
GROUP BY x) B
ON A.x = B.x