Re: Help, my developers are killing me with varchar2(4000)
From: <sybrandb_at_hccnet.nl>
Date: Mon, 11 Aug 2008 15:49:16 +0200
Message-ID: <sng0a4p22d5tnep5em9cn9qnjqfgcs709c@4ax.com>
Date: Mon, 11 Aug 2008 15:49:16 +0200
Message-ID: <sng0a4p22d5tnep5em9cn9qnjqfgcs709c@4ax.com>
On Mon, 11 Aug 2008 13:21:42 +0000 (UTC), Wolfram Roesler <wr_at_spam.la>
wrote:
> 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.
Secondly, a random length string datatype would cause heavy row
chaining, so kill performance.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Aug 11 2008 - 08:49:16 CDT