oracle一行变多行实现教程

oracle一行变多行实现教程

select regexp_substr('1,2,3,4,5,6,7,8,9', '[^,]+', 1, rownum) from dual connect by rownum <= length('1,2,3,4,5,6,7,8,9') - length(replace('1,2,3,4,5,6,7,8,9', ',', '')) + 1