select dbms_lob.substr (regexp_substr('abc,def,ggg,1,2,3,4,5', '[^,]+', 1, x.n)) as player_guid from dual a, (select rownum n from dual connect by rownum < 100) x
select dbms_lob.substr (regexp_substr('abc,def,ggg,1,2,3,4,5', '[^,]+', 1, x.n)) as player_guid from dual a, (select rownum n from dual connect by rownum < 100) x