Oracle把逗号分隔的字符串转为in可以引用的值

select regexp_substr('a,b,c,d','[^,]+', 1, level) from dual
connect by regexp_substr('a,b,c,d', '[^,]+', 1, level) is not null