Depends on the number. It takes up the number of digits in scientific
notation divided by 2 plus 1. The max is 22 bytes. To test it see do
select vsize(myNumColumn) from mytable where ....
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"J.Bokma" <jt.bokma_at_chello.nl> wrote in message
news:7Lsoa.73714$qm4.9626613_at_amsnews03.chello.com...
> Hello Everyone,
>
> My question is how many bytes of diskspace a number column takes .
> Both for NULL value and when it is NOT NULL.
> Is it different in Oracle 7 8 and 9
>
> Any suggestions ?
> JB
>
>
>
Received on Sun Apr 20 2003 - 08:28:50 CDT
