查詢某個 LOB 欄位的大小

select dbms_lob.getlength(field_name) from table_name where condition_clause;

範例:
   select dbms_lob.getlength(Blob1) from Table1 where UniqID=1
Oracle How To