Oracle 一行转多行
复制收展SQLselect regexp_substr(temp.col,'[^,]+',1, level)
from (select '1,2,3,4,5' as col from DUAL) temp
connect by level <= length(temp.col) - length(regexp_replace(temp.col,',',''))+1;- 1
- 2
- 3
Oracle 一行转多行 原创
没有更多推荐了 [去首页]
Oracle 一行转多行
复制收展SQLselect regexp_substr(temp.col,'[^,]+',1, level)
from (select '1,2,3,4,5' as col from DUAL) temp
connect by level <= length(temp.col) - length(regexp_replace(temp.col,',',''))+1;
QQ好友
QQ空间