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