Re: Length of BLOB file

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 13 Jul 2001 05:57:55 -0700
Message-ID: <9imr8j02hqe@drn.newsguy.com>

In article <9imp4u$ocf$00$1_at_news.t-online.com>, "Damir says...
>
>Hi!
>How to see through SQL statement how much bytes does BLOB field occupied?
>Regards
>Damir!
>
>
>

select dbms_lob.getlength( blob_column ) from t;

suggest you read some of the docs on this subject found at:

http://technet.oracle.com/doc/oracle8i_816/appdev.816/index.htm

blobs have lots of functionality -- you'll be missing alot if you don't read about them.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Fri Jul 13 2001 - 07:57:55 CDT