Re: varchar2(size)
From: <ricforduk_at_yahoo.co.uk>
Date: Wed, 30 Sep 2009 07:16:23 -0700 (PDT)
Message-ID: <9eeb4460-f662-4b06-bc41-3751d0bbcddf_at_t32g2000yqj.googlegroups.com>
On 30 Sep, 00:46, indytoatl <indyto..._at_gmail.com> wrote:
> If I have a table with 200 fields that are all variable length what
> would be the drawback be of making them all varchar2(100) so that I
> don't have to guess a number for each field. The form users fill out
> already has contraints for the same fields (ie, Last Name Field on
> form has 20 space limit.).
Date: Wed, 30 Sep 2009 07:16:23 -0700 (PDT)
Message-ID: <9eeb4460-f662-4b06-bc41-3751d0bbcddf_at_t32g2000yqj.googlegroups.com>
On 30 Sep, 00:46, indytoatl <indyto..._at_gmail.com> wrote:
> If I have a table with 200 fields that are all variable length what
> would be the drawback be of making them all varchar2(100) so that I
> don't have to guess a number for each field. The form users fill out
> already has contraints for the same fields (ie, Last Name Field on
> form has 20 space limit.).
This may interest you:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1145132537055
Received on Wed Sep 30 2009 - 09:16:23 CDT