Re: Numeric defs

From: Jos <jga.wolters_at_abp.nl>
Date: Mon, 21 Feb 2000 13:23:41 +0100
Message-ID: <88ram7$b66@sunsv007>

Hi,

The specification (6.3) has no influence on the storage needed, that just depends on what the column contains.
Type number takes (digits + 1)/2 + 1 bytes for the column only.

Jos

Jb <jbrouillette_at_iname.com> schreef in berichtnieuws S1Wq4.12017$8S2.314605_at_news1.rdc1.tn.home.com...
> What if any are the consequences of not qualifying a numeric column
>
> i.e.
>
> my_number NUMBER(6.3)
> vs.
> my_number NUMBER
>
> My main concern is storage size. We are back loading a massive amount of
> data and we do not trust the documentation that is available.
>
> thanks
>
>
>
>
>
>
Received on Mon Feb 21 2000 - 06:23:41 CST