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:[EMAIL PROTECTED] * 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).