1 sql
select regexp_substr('aaa,bbb,ccc','[^,]+',1,level) as subStr
from dual
connect by level<=length('aaa,bbb,ccc')-length(replace('aaa,bbb,ccc',','))+1;
2 查询结果
1 sql
select regexp_substr('aaa,bbb,ccc','[^,]+',1,level) as subStr
from dual
connect by level<=length('aaa,bbb,ccc')-length(replace('aaa,bbb,ccc',','))+1;
2 查询结果