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: Finding the size of a BLOB field

Re: Finding the size of a BLOB field

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 11 Jan 2002 13:00:06 -0000
Message-ID: <3c3ee1d8$0$8512$ed9e5944@reading.news.pipex.net>


SELECT DBMS_LOB.GETLENGTH(BLOBCOL) FROM TAB WHERE <WHERE CLAUSE>;

was what I meant. This seems pretty efficient to me.

"Ati Rosselet" <ati.rosselet_at_clarmont.hu> wrote in message news:a1mj97$bb6$1_at_proxy.interware.hu...
> But that only works if you first extract the blob.. right? I'm looking
for
> something to just query the size (as in vsize), without having to excract
to
> get an object and then query that - for a large db with large blobs, that
> would REALLY slow things down.. no?
> -Thanks
> Ati
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3c3ecce2$0$231$ed9e5944_at_reading.news.pipex.net...
> > dbms_lob.get_length
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Ati Rosselet" <ati.rosselet_at_clarmont.hu> wrote in message
> > news:a1mi9v$atu$1_at_proxy.interware.hu...
> > > Is there any way (I cant find one so far) of determining the actual
size
> > (in
> > > bytes) of a BLOB field? vsize is great for all other field types..
but
> > > doesnt want to work on blob. any ideas?
> > > Thnx
> > > -Ati
> > >
> > >
> >
> >
>
>
Received on Fri Jan 11 2002 - 07:00:06 CST

Original text of this message

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