Re: Oracle: why should one specify the width of a number column?
Date: Wed, 9 Sep 2009 05:55:14 -0700 (PDT)
> COUNTRY_CD NUMBER(10) <
This looks a bit oversized. The standard for this (ISO 3166 alpha-2) is made up by two letters, so country_cd CHAR(2) would look more appropriate. If you are using the numeric or the alpha-3 version of ISO 3166 you would have CHAR(3)
Philipp Post Received on Wed Sep 09 2009 - 07:55:14 CDT