oracle 拆分字符串 

SELECT * FROM(
SELECT REGEXP_SUBSTR('{2}', '[^,]+', 1, LEVEL, 'i') AS STR   
  FROM DUAL  
CONNECT BY LEVEL <=   
           LENGTH('{2}') 
           - LENGTH(REGEXP_REPLACE('{2}', ',', ''))+1)

 

posted @ 2018-05-02 15:29  夏风微凉  阅读(224)  评论(0)  编辑  收藏  举报