oracle一行变多行实现教程
程序员文章站
2022-03-23 20:37:25
oracle一行变多行实现教程
select regexp_substr('1,2,3,4,5,6,7,8,9', '[^,]+', 1, rownum) fro...
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