select * from 表名 where id in (
SELECT REGEXP_SUBSTR(列名,'[^(分割字符串的符号(比如逗号))]+', 1, LEVEL) FROM DUAL
CONNECT BY REGEXP_SUBSTR(列名,'[^(分割字符串的符号(比如逗号))]+', 1, LEVEL) IS NOT NULL
)
-- 例子
select * from user where id in (
SELECT REGEXP_SUBSTR(ids,'[^,]+', 1, LEVEL) FROM DUAL
CONNECT BY REGEXP_SUBSTR(ids,'[^,]+', 1, LEVEL) IS NOT NULL
)
Oracle将字符串逗号分隔放入in中作为条件查询
最新推荐文章于 2023-11-18 16:44:23 发布