Re: Oracle: why should one specify the width of a number column?

From: Philipp Post <post.philipp_at_googlemail.com>
Date: Wed, 9 Sep 2009 05:55:14 -0700 (PDT)
Message-ID: <851b9648-f1cc-4ae4-8c86-1ce3d17ed3cb_at_l13g2000yqb.googlegroups.com>



> 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)

http://www.iso.org/iso/english_country_names_and_code_elements http://en.wikipedia.org/wiki/ISO_3166-1

brgds

Philipp Post Received on Wed Sep 09 2009 - 07:55:14 CDT

Original text of this message