REGEXP_SUBSTR的使用:
通过REGEXP_SUBSTR进行数据分割;
SELECT 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;
查询结果:
REGEXP_SUBSTR的使用:
通过REGEXP_SUBSTR进行数据分割;
SELECT 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;
查询结果:
转载于:https://www.cnblogs.com/yx007/p/6739953.html