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
原文：https://www.cnblogs.com/yshyee/p/13293135.html