一、计算clob或者blob字段的大小dbms_lob.getlength(字段名)
select attachment_title, dbms_lob.getlength(attachment_content) / (1024*1024) num
from office_workflowattachment
order by num desc
一、计算clob或者blob字段的大小dbms_lob.getlength(字段名)
select attachment_title, dbms_lob.getlength(attachment_content) / (1024*1024) num
from office_workflowattachment
order by num desc