Re: Size of datatype NUMBER
From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Wed, 25 Feb 2009 14:56:33 GMT
Message-ID: <B_cpl.1526$Ez6.1394_at_nwrddc02.gnilink.net>
Date: Wed, 25 Feb 2009 14:56:33 GMT
Message-ID: <B_cpl.1526$Ez6.1394_at_nwrddc02.gnilink.net>
"Norbert Pürringer" <thalion77_at_graffiti.net> wrote in message
news:35dce30e-e971-4d23-97e3-bd0e07c18177_at_v15g2000yqn.googlegroups.com...
> Hello,
>
> what is the size of the Oracle datatype NUMBER in bytes?
>
> Thank you,
> Norbert
It depends on the number. It can be as large as 22 bytes. In Oracle numbers
are stores in base 100 so a good approximation is logbase10(the number)/2 +1
. Numbers are internally expressed in scientific notation so 1,000,000,000
isn't much larger than 10 in terms of storage. You can be empirical about
it using vsize eg select vsize(mynumbercolumn) from mytable;
Received on Wed Feb 25 2009 - 08:56:33 CST