REGEXP_SUBSTR(
‘17,20,23‘,
‘[^,]+‘,
1,
LEVEL,
‘i‘)
AS STR
FROM DUAL CONNECT
BY LEVEL <=
LENGTH(‘17,20,23‘)
- LENGTH(REGEXP_REPLACE(
‘17,20,23‘,
‘,‘,
‘‘))
+1;
查询结果:

【oracle】oracle REGEXP_SUBSTR分割字符串
标签:style nec from ora http bst com color evel