Re: Table sizing question

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/08
Message-ID: <339a4f61.3647872@www.sigov.si>#1/1

On Sat, 07 Jun 1997 17:55:14 -0500, Bob B <bobo_at_cyberramp.net> wrote:

>The definition of a "NUMBER" says that it can occupy up to 21 bytes.
>
>What are the acctual column sizes (number of bytes required) for
>something like

Remember that Oracle stores numbers in variable length format, so from column definition you can determine only the maximum storage size for that column. Actual storage size depends on numbers stored in that column.

>
>NUMBER(5) (a short integer range)

Can occupy from 1 (for value 0) to 5 bytes (for value -99999)

>NUMBER(10) (an integer range)

Can occupy up to 7 bytes

>NUMBER(14.7) (a float range)

Can occupy up to 9 bytes

>NUMBER(22.15) (a double range)

Can occupy up to 13 bytes

>And what gave you that information?

Oracle Server Concepts guide, chapter about datatypes.

>Thanks
>
>BB

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Sun Jun 08 1997 - 00:00:00 CDT