Re: Size of datatype NUMBER

From: gym dot scuba dot kennedy at gmail <>
Date: Wed, 25 Feb 2009 14:56:33 GMT
Message-ID: <B_cpl.1526$>

"Norbert Pürringer" <> wrote in message
> 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

Original text of this message