Oracle connect by level

test

https://stackoverflow.com/questions/38371989/how-to-convert-comma-separated-values-to-rows-in-oracle

 

select id, trim(regexp_substr(value,'[^,]+', 1, level) ) value, level
  from tbl1
   connect by regexp_substr(value, '[^,]+', 1, level) is not null
          and prior id = id
          and prior sys_guid() is not null
   order by id, level;