Re: Datatype numeric

nieuws net wrote on 27-Apr-99 10:40:18:
>Hi all

Hello out there!

>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

Well, Oracle stores numbers in a variable data format. If you say just number and not number(5,2) or the like, 22 bytes is the maximum amount of space, a number can take up.
To do some more realistic space estimation you should consider the precision and scale fields of user_tables.

>gkor_at_rdw.nl

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |