Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB size calculating

Re: BLOB size calculating

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 22 Apr 2003 16:03:19 +0400
Message-ID: <b83b29$jk1$1@babylon.agtel.net>


"Roman Grigoryan" <romich_at_dukascopy.com> wrote in message news:3ea3cec1$1_5_at_news.bluewin.ch...
> Hello,
>
> How to calculate BLOB size and BLOB objects size age for a table?
>
> Thanx

DBMS_LOB.getLength() - look it up in Supplied PL/SQL Packages Reference for more info.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Apr 22 2003 - 07:03:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US