Re: Help, my developers are killing me with varchar2(4000)
From: Wolfram Roesler <wr_at_spam.la>
Date: Mon, 11 Aug 2008 15:53:54 +0000 (UTC)
Message-ID: <Xns9AF7B61369556wrgrpde@78.46.73.112>
>
> That question doesn't need to be asked.
Date: Mon, 11 Aug 2008 15:53:54 +0000 (UTC)
Message-ID: <Xns9AF7B61369556wrgrpde@78.46.73.112>
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.
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