Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_lob.getlength()

865957Feb 22 2012 — edited Feb 23 2012
Hi all,
I need the length of a BLOB column. I realized that the function dbms_lob.getlength() does this job. However, I wonder if this function "computes" the length of the BLOB data which is given as a parameter, or "retrieves" it from the metadata the BLOB keeps (if there are such metadata of the BLOBs).
I have to get lengths of BLOB data in all rows of a huge-size table; and I have to consider time issues. Therefore, if a costly computation will be done when I call dbms_lob.getlength() for each row, I will keep the length of the BLOBs as a separate column (like a metadata).
Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2012
Added on Feb 22 2012
3 comments
508 views