select * from (select dbms_lob.substr(regexp_substr('888;12791;98672;', '[^;]+', 1, x.n)) as player_guid
from dual a, (select rownum n from dual connect by rownum < 100) x) where player_guid is not null
select * from (select dbms_lob.substr(regexp_substr('888;12791;98672;', '[^;]+', 1, x.n)) as player_guid
from dual a, (select rownum n from dual connect by rownum < 100) x) where player_guid is not null