Re: Easy number question.

From: Luc Gyselinck <lgy_at_athylon.be>
Date: 1997/10/20
Message-ID: <01bcdd50$8712a700$690c79c1@PC92-LGY.athylon.be>#1/1

This is a multi-part message in MIME format.

------=_NextPart_000_01BCDD61.4A9B7700
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

Oracle only stores the most significant bytes to the database blocks for NUMBERS.
This means that small numbers use less space than large numbers (variable length!)
The length of the number is only used to verify the range of the value of the column.

Vaughan Castine <vaughan_at_unforgettable.com> wrote in article <621nja$5bh$1_at_opera.iinet.net.au>...
> I hope its easy...
>
> If I define a field to be of type NUMBER(x) does the storage of this
field
> vary with x.
>
> ie Do 2 fields one of NUMBER(1) and the other NUMBER(99) have the same
> storage overhead?
>
> Thanks in advance.

------=_NextPart_000_01BCDD61.4A9B7700
Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

<html><head></head><BODY bgcolor=3D"#FFFFFF">Oracle only stores the most significant = bytes to the database blocks for NUMBERS. This means that small = numbers use less space than large numbers (variable length!) The = length of the number is only used to verify the range of the value of = the column. Vaughan Castine <<font =

color=3D"#0000FF"><u>vaughan_at_unforgettable.com</u><font =
color=3D"#000000">&gt; wrote in article &lt;<font =
color=3D"#0000FF"><u>621nja$5bh$1_at_opera.iinet.net.au</u><font =
color=3D"#000000">&gt;...<br>&gt; I hope its easy...<br>&gt; <br>&gt; If =

I define a field to be of type NUMBER(x) does the storage of this = field > vary with x. > > ie Do 2 fields one of = NUMBER(1) and the other NUMBER(99) have the same > storage = overhead? > > Thanks in advance. </body></html> ------=_NextPart_000_01BCDD61.4A9B7700-- Received on Mon Oct 20 1997 - 00:00:00 CDT