I'm getting the same results from

select length(column_name) from table

as from

select dbms_lob.getlength(column_name) from table

However, the answers to this question seem to favor using dbms_lob.getlength().

Is there any benefit to using dbms_lob.getlength()?

If it changes the answer, I know all of the BLOBs are .bmp images (never worked with BLOBs before).

sql oracle-database blob
Edit
Report