February 15, 2014

Oracle DB: Get BLOB field size in sql query

Post author:admin
Post published:February 15, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

This is how to get the size of a BLOB in SQL query:select file_id, doc_xml, dbms_lob.getlength(doc_xml) from my_files order by dbms_lob.getlength(doc_xml) desc