Oracle LOB

with c1 as (select trunc(dbms_lob.getlength(XML_TO_NETA)/4000) as gruppo from COMMON.AB_TRACKING) select gruppo,count(*) from c1 group by gruppo;

with c1 as
 (select case when lungh between 0 and 3999 then 'inrow'
              when lungh between 4000 and 8192 then 'chunk'
              when lungh is null then 'empty'
             else 'bigger' end lunghezza
      from (select dbms_lob.getlength(DATA) as lungh from STAMPATORE.QUEUETABLE ))
select lunghezza,count(*) from c1 group by lunghezza;