Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Data Types
Date - 7 bytes.
Long raw - 1 byte plus the size
raw - the size
Numbers (all) log base 10 of the number (ignoring the decimal) /2 plus 2
rounded up
so the number 199 is really 2 bytes (log 10(199) = 2/2=1+2=3) If you use
all 38 digits of precision then 22 bytes. It stores it in base 100 with an
offset for the exponent and then you need space for the sign. So it does
not matter what type of number, but the precision of it.
Jim
kal121_at_yahoo.com wrote in message <72d2s1$f5g$1_at_nnrp1.dejanews.com>...
>Hello,
>
>Once and for all I would like a straight answer on this (because I can't
seem
>to find it anywhere!)
>
>What are the sizes for the following data types in Oracle:
>
>FLOAT
>NUMBER( )
>INTEGER
>DECIMAL
>LONG RAW
>RAW
>DATE
>ETC...
>
>Thank you in advance
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Nov 11 1998 - 22:03:20 CST