欢迎投稿

今日深度:

oracle一行变多行实现教程,oracle多行

oracle一行变多行实现教程,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

www.htsjk.Com true http://www.htsjk.com/oracle/24404.html NewsArticle oracle一行变多行实现教程,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, ,, )) +...
评论暂时关闭