Re: Size of datatype NUMBER
Date: Wed, 25 Feb 2009 14:56:33 GMT
"Norbert Pürringer" <thalion77_at_graffiti.net> wrote in message
> what is the size of the Oracle datatype NUMBER in bytes?
> Thank you,
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