oracle 拆分字段为多行

WITH c AS
 (SELECT x.wms_jc_uuid FROM FENTAN_LOT x WHERE LENGTH(SHOP_ORDER) > 15),
tt as
 (SELECT wms_jc_uuid, REGEXP_SUBSTR(wms_jc_uuid, '[^;]+', 1, L)
    FROM c, (SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 100) Bb
   WHERE L <=
         LENGTH(wms_jc_uuid) - LENGTH(REPLACE(wms_jc_uuid, ';', '')) + 1)
select * from tt order by 1