RE: Varchar2....is this Dilbert or what?????

if any varchar column is indexed... dont try to do an insert or update on this (u will wait... wait... wait.... ) .

And, I agree, why 255?. Why not 256?, or 283982783?... .or 849.232?...

Oh, by the way, I liked this argument "to keep maintenace down in the future, so we don't have to
change the database every time when need a column resized". I think its not a big cost... and of course you can avoid it thinking on the use of each column.

Developer error... replace developer to continue

Carlos....

> ----------
> De: I.S. Manager[SMTP:ismgr_at_pctc.com]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Martes 9 de Mayo de 2000 19:48
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Varchar2....is this Dilbert or what?????
>
> sql-generated reports are going to be kind of hard to read....
>
> At 02:04 PM 5/9/00 -0800, Christine Turner wrote:
> >Ok, forgive me if I offend anyone....but the head honchos came and
> asked
> >what the ramifications would be if we were to make every, yes EVERY
> >varchar2 column in new database the length of 255. The reasoning
> behind
>
> ---
> Dennis Taylor
> ---
> The opinions expressed herein are mine. Get your own opinions!
> ---
> --
> Author: I.S. Manager
> INET: ismgr_at_pctc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue May 09 2000 - 17:18:34 CDT