select
'1,2,3,4,5,6,7,8,9'
from
dual;
SELECT
REGEXP_SUBSTR(
,
'[^,]+'
, 1,
ROWNUM)
FROM
DUAL
connect
BY
ROWNUM <= LENGTH(
) - LENGTH(
REPLACE
(
','
''
)) + 1;
by: 发表于:2017-09-28 14:49:03 顶(0) | 踩(0) 回复
??
by: 发表于:2017-09-28 14:49:03 顶(0) | 踩(0) 回复
??
回复评论