Re: Storage space of NUMBER

Just do a select dump(1234) from dual;
DUMP(1234)

2 (not stored but is the datatype of a number) 194 encodes the sign and the decimal place 13 (substract 1 gives you 12
35 (subtract 1 gives you 34)
= + 1234.0
If you really want the full details mail me .

Nigel.

Cable Services Group (r.dunham_at_gonix) wrote:
: 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.

--
                                  _____________
    Nigel Noble                       churchill        Tel: +44 81 313 5677
    Database Administrator        =============        Fax: +44 81 313 5699
    Churchill Technology Ltd
    15-17 London Rd, Bromley BR1 1DE, UK.    Email: nigel_at_churchill.co.uk