oracle一行变多行实现教程

	oracle一行变多行实现教程 SELECT REGEXP_SUBSTR('1,2,3,4,5,6,7,8,9', '[^,]+', 1, ROWNUM) FROM DUAL C ONNECT BY ROWNUM <= LENGTH('1,2,3,4,5,6,7,8,9') - LENGTH(REPLACE ('1,2,3,4,5,6,7,8,9', ',', '')) + 1 复制代码