Re: CLOBs storage vs Varchar storage

Monday, August 13, 2001, 1:50:28 PM, Clark wrote:
>> CLOBs vs VARCHAR. If a varchar datatype is not completely used it will
>> not allocate storage for what is was defined.
>> Does a CLOB data type use entire storage if not completely used?

No. If you think about it long enough, you'll realize that could never be the case. When you define a CLOB, you don't specify a maximum length as you do when you define a VARCHAR2. The max length of any CLOB column, therefore, is the max length of a CLOB period, which is 4 gigabytes. A CLOB column would not be of much use if every small value that you put into it took up an entire 4 gigs. Some simple testing will show you that is not the case.

Best regards,

Jonathan Gennick
mailto:jonathan_at_gennick.com * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: jonathan_at_gennick.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).