Re: Help, my developers are killing me with varchar2(4000)

From: Wolfram Roesler <>
Date: Mon, 11 Aug 2008 15:53:54 +0000 (UTC)
Message-ID: <Xns9AF7B61369556wrgrpde@> wrote in news:sng0a4p22d5tnep5em9cn9qnjqfgcs709c@

>> Neither has the question been asked why Oracle doesn't support
>>a random length string datatype.

> That question doesn't need to be asked.

Why not?

> First of all Oracle already has CLOBs for this purpose, since 8.0, so
> in the previous milennium.

Can a CLOB be used in the same way a VARCHAR2 can be used, e. g. in SELECT, UPDATE, WHERE, ORDER BY, GROUP etc.?

> Secondly, a random length string datatype would cause heavy row
> chaining, so kill performance.

Could you elaborate on this?

Thanks and best regards
W. Rösler Received on Mon Aug 11 2008 - 10:53:54 CDT

Original text of this message