DBMS_LOB.GetLength returns the number of characters (bytes) in the CLOB/BLOB column.
SELECT DBMS_LOB.GetLength("BlobColum")/1024/1024 AS SizeMB FROM MY_SCHEMA.MY_TABLE_WITH_BLOB_CLOB
Discover more about Jun Kim
DBMS_LOB.GetLength returns the number of characters (bytes) in the CLOB/BLOB column.
SELECT DBMS_LOB.GetLength("BlobColum")/1024/1024 AS SizeMB FROM MY_SCHEMA.MY_TABLE_WITH_BLOB_CLOB