Take a look at my tips under forums on www.vampired.net. It has a very good
explaination on how oracle stores numeric types.
-Original Message-
Sent: Wednesday, July 11, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
Can someone point me a document or something that
explains ho
See Note: 1031902.6 "How Does Oracle Store Internal
Numeric Data?" for more details.
HTH,
-- Anita
--- Pablo ksksksk <[EMAIL PROTECTED]> wrote:
> Can someone point me a document or something that
> explains how does Oracle store NUMBER datatypes
> internally?
>
> TIA
>
>
_
Without checking the manual (corrections welcome):
Byte 1: number of bytes for storage (# of digits divided by 2)
Byte 2: where the decimal goes (not sure of exact format)
Byte 3-x: pairs of digits
1576.89
gets stored something akin to:
decimal:4 2(4?) 15 76 89
HEX:04 02 0f 4