Re: Number vs Number(x)

From: Shajith, T V <shajith_thaze_at_bose.com>
Date: 1997/12/09
Message-ID: <01bd04be$5f55d580$78b3448b@jmartintemp.bose.com>#1/1

When you specify numeric fields, it is a good idea to specify the precision and scale. This provides extra integrity checking on input.

Douglas Scott <Douglas.S.Scott_at_boeing.com> wrote in article <348D53F5.89D7CC06_at_boeing.com>...
> If you are defining a field in a table that will contain integer data is
> it better to define the field with respect to its associated length (if
> max value will be 999 then define field as NUMBER(3)) or to generically
> define it as NUMBER?
>
> Douglas Scott
> Douglas.S.Scott_at_boeing.com
>
>
Received on Tue Dec 09 1997 - 00:00:00 CST