Re: Storage space of NUMBER
From: Scott Urman <surman_at_wwsun10.us.oracle.com>
Date: 19 Sep 1994 16:57:37 GMT
Message-ID: <35kfu1$aka_at_dcsun4.us.oracle.com>
Date: 19 Sep 1994 16:57:37 GMT
Message-ID: <35kfu1$aka_at_dcsun4.us.oracle.com>
In article <Cw82A3.1Lo_at_gonix.com>, r.dunham_at_gonix (Cable Services Group) writes:
|> How does Oracle physically store the NUMBER datatype? For example in
|> Sybase, a NUMBER(10) whould store as 6 bytes -- 2 mininum and 1 byte for
|> every 2 digits.
Numbers are stored in a variable length, floating point, DECIMAL format. Not binary. This is done for greater precision and to insure portability across operating systems. The maximum length of a number is 21 bytes. You can see how many bytes are stored for a particular value by selecting dump() of that column. Received on Mon Sep 19 1994 - 18:57:37 CEST