Oracle Database - How to get the length of a blob Mar 2, 2021 If your blob is a long string, the easiest way to get its length is to use one of Oracle stored procedures dbms_lob.getlength: select dbms_lob.getlength(YOUR_BLOB_COLUMN) from YOUR_TABLE; Tested with Oracle 12.