Oracle中把逗号分割的字符串转换为可放入in的条件语句的字符数列

select regexp_substr('SMITH,ALLEN,WARD,JONES','[^,]+', 1, level) from dual
connect by regexp_substr('SMITH,ALLEN,WARD,JONES', '[^,]+', 1, level) is not null


©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页