Oracle 计算部分表大小

select sum(
  length(varchar2_col)+  -- string
  7 +                    -- date col
  13 +                   -- timestamp col
  length(num_col)/2 +    -- numeric col
  dbms_lob.getlength(c)  -- lob col
)
from my_table
where ...
复制