select '1,2,3,4,5,6,7,8,9' from dual; 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;
by: 发表于:2017-09-28 14:49:03 顶(0) | 踩(0) 回复
??
by: 发表于:2017-09-28 14:49:03 顶(0) | 踩(0) 回复
??
回复评论