问题:
每次数据库查询的时候 ,当in里面的参数个数大于1000以后就会报错
解决方法:
使用分割+ JOIN 代替IN
SELECT * FROM EMPLOYEE E WHERE E.ID IN (‘071569’,‘071568’);
– 可以替换为
SELECT * FROM EMPLOYEE E
JOIN
(
SELECT
– 正则分割
REGEXP_SUBSTR(‘071569,071568’, ‘[^,]+’, 1, LEVEL) VALUE,LEVEL
FROM
DUAL
CONNECT BY
LEVEL <= REGEXP_COUNT(‘071569,071568’, ‘[^,]+’)
) TEMP ON E.ID = TEMP.VALUE;