Re: Weird advice : keep varchar2 under 255 bytes ???

Le JeanMimi wrote:

> Hello,
>
> A developer told us that it was best to avoid declaring VARCHAR2
> columns of more than 255 bytes when possible.
> He pretends that Oracle will reserve huge blocks for the resultset
> when the varchar2 size is over 255.
>
> I've never heard of that before. (and don't really believe it)
> May be in a previous version ?
>
> Can you help me ?
>
> Thanks in advance
>
> JM

Find a new developer or send this one for some training.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)