Oracle - String Split

Oracle - String Split

 

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

文章來源