Oracle中将字符串转化为in的条件

SELECT REGEXP_SUBSTR(v_name, '[^,]+', 1, LEVEL) FROM DUAL
CONNECT BY REGEXP_SUBSTR(v_name, '[^,]+', 1, LEVEL) IS NOT NULL

posted @ 2021-02-22 14:22 xxlfly 阅读(695) 评论(0) 收藏举报