Oracle LOB: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " 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; Categoria:Oracle Cate...") |
Nessun oggetto della modifica |
||
Riga 1: | Riga 1: | ||
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 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; |
|||
[[Categoria:Oracle]] |
[[Categoria:Oracle]] |
Versione delle 23:50, 14 ott 2021
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;