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 - 14:55:14 CEST

This message: [ Message body ]
Next message: vldm10: "Re: Patent for relational theory for OO memory management?"
Previous message: paul c: "Re: More on view updates and inverse views"
In reply to: VTR250: "Oracle: why should one specify the width of a number column?"
In reply to VTR250: "Oracle: why should one specify the width of a number column?"
Next in thread: vldm10: "Re: Patent for relational theory for OO memory management?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message