There are two types of researchers. Those who have done something and those who haven't. The latter will say there are 143 ways to do something, and the former will say 142 of them don't work. - Quote from a System V researcher
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;