Re: Datatype numeric

From: Ralph Ganszky <ralph.ganszky_at_sap-ag.de>
Date: Sat, 01 May 1999 15:30:52 +0200
Message-ID: <372B020C.FC1D118C@sap-ag.de>

The Oracle documentation contain the answer to the question in the Oracle8 Concepts.

1 byte (exponent)
+ FLOOR(p/2)+1 bytes (mantissa)
+ 1 byte (only for a negative number where the number of significant digits is less than 38)

---

number of bytes of data

where p is the precision of the number (the scale has no effect for the space calculation).

I hope this will help You

Kind regards
Ralph Ganszky

nieuws net schrieb:

> Hi all
>
> when i create a table with datatype numeric (it does not matter how long)
> and when i select the view user_tab_columns
> i see that all columns with datatype numeric are 22 bytes long.
> When i try to size a table with those data , i reserve too much space.
>
> who can help
>
> gkor_at_rdw.nl
Received on Sat May 01 1999 - 08:30:52 CDT