Re: Length of BLOB file

From: Bastiaan Schaap <fake_address_at_nomail.com>
Date: Fri, 13 Jul 2001 15:45:57 +0200
Message-ID: <FWC37.16$4v1.808@psinet-eu-nl>

Hi Damir,

SELECT dbms_lob.getlength( a.lob_field ) AS blob_length FROM my_table a WHERE .......;
will return the length of the blob in bytes.

So you can use dbms_lob.getlength. It is overloaded:

FUNCTION dbms_lob.getlength( lob_loc IN BLOB ) RETURN INTEGER; FUNCTION dbms_lob.getlength( lob_loc IN CLOB CHARACTER SET ANY_CS ) RETURN INTEGER;
FUNCTION dbms_lob.getlength( file_loc IN BFILE ) RETURN INTEGER;

HTH, Bastiaan Schaap

---

BACHELOR: A man who never makes the same mistake once.

"Damir Vadas" <Damir.Vadas_at_trinity.de> wrote in message news:9imp4u$ocf$00$1_at_news.t-online.com...
> Hi!
> How to see through SQL statement how much bytes does BLOB field occupied?
> Regards
> Damir!
>
>
>
Received on Fri Jul 13 2001 - 08:45:57 CDT