Oracle LOB
Jump to navigation
Jump to search
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;