lllove0702的专栏

oracle in 查询

例如字符串“123,456,789” SELECT * FROM TAB_A T1 WHERE T1.CODE IN ( SELECT REGEXP_SUBSTR(“123,456,789”,'[^,]+', 1, LEVEL) FROM DUAL CONNECT BY REGEXP_SUBSTR('SMITH,ALLEN,WARD,JONES', '[^,]+', 1, LEVEL) IS NOT NULL ) REGEXP_SUBSTR函数解释 REGEXP_SUBSTR(Stri...