orcale 实现 sql server 里面的表值函数SPLIT

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;

查询结果

 

 更多实现方法 和出处： https://www.cnblogs.com/huak/p/8125115.html

 sql server 里面的表值函数SPLIT： http://blchen.com/split-function-in-sql-server/