develop

오라클 Blob 용량 표시

파드파드 2023. 11. 13. 10:43
반응형

오라클 Blob 용량 표시

byte, kbyte, mbyte, gbyte

select --count(*) 
sum(dbms_lob.getlength(a.blob_col)) byte
, sum(dbms_lob.getlength(a.blob_col)/1024) kbyte
, sum(dbms_lob.getlength(a.blob_col)/1024/1024) mbyte
, sum(dbms_lob.getlength(a.blob_col)/1024/1024/1024) gbyte
from tab1 a

 

반응형