SELECT
*
FROM TAB_A T1
WHERE T1.CODE IN (
SELECT REGEXP_SUBSTR (‘1,2,3,4,5,6,7,8,9,0’,’[^,]+’,1,LEVEL)
FROM DUAL
CONNECT BY REGEXP_SUBSTR (‘1,2,3,4,5,6,7,8,9,0’,’[^,]+’,1,LEVEL) IS NOT NULL
)
orcale 以逗号切割某个字符串 放入in中
最新推荐文章于 2023-11-18 16:44:23 发布