RE: size of Clob

From: Biddell, Ian <Ian.Biddell_at_compaq.com>
Date: Wed, 23 May 2001 18:30:44 -0700
Message-ID: <F001.0030CC6F.20010523182025@fatcity.com>

Hi Ravindra

You can do

select dbms_lob.getlength(lob_column) from lob_table;

The returned value will be the number of bytes in your LOB column. I have done this for a CLOB field in one of our databases.

HTH
Ian

-----Original Message-----
Sent: Thursday, 24 May 2001 11:20
To: Multiple recipients of list ORACLE-L

I have a column of Clob datatype in one table.How Can I find the size of the data in a row for that Clob column alone.

Is this possible?

Thanks
Ravindra
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ravindra Basavaraja
INET: ravindra_at_sentica.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Biddell, Ian
INET: Ian.Biddell_at_compaq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------