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