Tuesday, September 13, 2011

SQL Sinppet : Size of BLOB for each row.

Assuming there's a table with a blob column to get the size of each row's blob size
select object_name,DBMS_LOB.GETLENGTH(blob_column) from table;
or
select object_name,lengthb(blob_column) from table;