oracle 使用REGEXP_SUBSTR正则表达式拆分字符串

SELECT REGEXP_SUBSTR ('first field, second field , third field', '[^,]+', 1,rownum)
    FROM DUAL
    CONNECT BY ROWNUM <=
   LENGTH ('first field, second field , third field') - LENGTH (REPLACE ('first field, second field , third field', ',', ''))+1;

------------------------------------------------------------------------------
first field
second field
third field
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/guijl/p/4045386.html