Re: Oracle Blobs - size calculation

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 2 Jan 2007 09:39:21 -0800
Message-ID: <1167759561.864825.211560@v33g2000cwv.googlegroups.com>

thekaran wrote:
> Hello,
>
> I have a table with thousands of blobs on it. I need to calculate the
> physical size of the blobs resulting from my specific query. For
> example, i need to calculate the total size of blobs that are between
> blob ids 4000 to 5000.
>
> the table consist of id (INT) and content (BLOB) as columns.
>
> would someone help me?

Hi,

Try dbms_lob.getlength()

Regards,

Steve Received on Tue Jan 02 2007 - 11:39:21 CST