yelu8000的博客

原创 oracle逗号内容分割

SELECT REGEXP_SUBSTR('11,22,33', '[^,]+', 1, LEVEL, 'i') AS STR   FROM DUAL CONNECT BY LEVEL            LENGTH('11,22,33') - LENGTH(REGEXP_REPLACE('11,22,33', ',', '')) + 1 结果： 11 22 33 可以用于i