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;

 

 查询结果:

 

posted on 2017-04-25 11:36  yxtic  阅读(2544)  评论(0编辑  收藏  举报