Re: Help, my developers are killing me with varchar2(4000)
Date: Mon, 11 Aug 2008 15:53:54 +0000 (UTC)
sybrandb_at_hccnet.nl wrote in news:sng0a4p22d5tnep5em9cn9qnjqfgcs709c@ 4ax.com:
>> Neither has the question been asked why Oracle doesn't support >>a random length string datatype.
> That question doesn't need to be asked.
> 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