SELECT
ID
FROM
table ta
WHERE
ta.ID IN (
SELECT regexp_substr('#{ids}','[^,]+', 1, level) FROM DUAL
CONNECT BY REGEXP_SUBSTR('#{ids}', '[^,]+', 1, LEVEL) IS NOT NULL
)
ids示例:1,2,3
SELECT
ID
FROM
table ta
WHERE
ta.ID IN (
SELECT regexp_substr('#{ids}','[^,]+', 1, level) FROM DUAL
CONNECT BY REGEXP_SUBSTR('#{ids}', '[^,]+', 1, LEVEL) IS NOT NULL
)
ids示例:1,2,3