Oracle实现split功能，把字符串拆分成多行处理

spuuids字段内容为：'08A7A8D9DDF3AB4923428C7883DDBA49,14A44FC2B4EF434C274489FC1DDAA9D9,C055DB766347D6C78854671C7383AC26'

 

SELECT regexp_substr(t.spuuids,'[^,]+',1,ROWNUM) AS spuuid
  FROM XX t
  WHERE t.jbdbh='20200713140001476'
  CONNECT BY ROWNUM<=LENGTH (t.spuuids) - LENGTH (regexp_replace(t.spuuids, ',', ''))+1

 

posted @ 2020-07-13 14:43  yshy  阅读(2160)  评论(0)  编辑  收藏  举报