varchar2(size)
From: indytoatl <indytoatl_at_gmail.com>
Date: Tue, 29 Sep 2009 16:46:03 -0700 (PDT)
Message-ID: <91105a76-cd91-4935-820f-b614b0695c03_at_k41g2000vbt.googlegroups.com>
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.). Received on Tue Sep 29 2009 - 18:46:03 CDT
Date: Tue, 29 Sep 2009 16:46:03 -0700 (PDT)
Message-ID: <91105a76-cd91-4935-820f-b614b0695c03_at_k41g2000vbt.googlegroups.com>
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.). Received on Tue Sep 29 2009 - 18:46:03 CDT