Re: How to get the size of a BLOB column

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 31 Mar 2001 10:36:04 +0100
Message-ID: <3ac5a5c8$0$12249$cc9e4d1f@news.dial.pipex.com>

Look at the documentation for the DBMS_LOB package. I believe the syntax for what you want is

select DBMS_LOB.LENGTH(column) but as i'm not near my docs I wouldn't swear to it.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Tao Y. Ge" <tao_at_nextengine.com> wrote in message
news:tcafg8gursgofe_at_corp.supernews.com...


> Hi,

>

> I am looking for the Oracle equivalent of the MSSQL's DATALENGTH function.

>

> in mssql if I do a SELECT DATALENGTH(blobcolumn) from TABLENAME

> I get back a list of sizes of those BLOBs.

>

> How would I do something similar in ORACLE?

>

> any help will be greatly appreciated.

> thanks.

>

> --

>

> Tao Ge

> Software Engineer

> tao_at_nextengine.com

> (310) 883-1837

>

> NextEngine, Inc.

> 401 Wilshire Blvd., Ninth Floor

> Santa Monica, California 90401

>

>

>

Received on Sat Mar 31 2001 - 03:36:04 CST