RE: space taken up by number data types

From: <Alexander.Feinstein_at_mitchell1.com>
Date: Tue, 14 Oct 2003 14:24:25 -0800
Message-ID: <F001.005D3162.20031014142425@fatcity.com>

Jared, Ryan,

Number data types does not reserved any space. Amount of used spaced depend on the stored value. For the same value size is the same, however, look at Steve Adams' site or run this test and see:

drop table t;
create table t (n1 number(3), n2 number); insert into t values(10/3,10/3);
insert into t values(3,3);
commit;
select * from t;
select vsize(n1), vsize(n2) from t;
select dump(n1), dump(n2) from t;
drop table t;

Alex.

-----Original Message-----
Sent: Tuesday, October 14, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L

Tom's right.

It's been this way since at least 7.0.12

"Ryan" <rgaffuri_at_cox.net>
Sent by: ml-errors_at_fatcity.com
 10/14/2003 02:09 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> 
        cc:         
        Subject:        space taken up by number data types

I could have swarn I read that Precision with number data types effects how much space is reserved in the database. So number(38) and number(3) reserve different amounts of space.   

Here is a link from Tom Kyte in 1998 saying the opposite. Is what he says still true?   

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=355e25d0 .17874392%40192.86.155.100&rnum=1&prev=/groups%3Fas_q%3Dnumber%2520datatype% 2520storage%26safe%3Dimages%26ie%3DUTF-8%26oe%3DUTF-8%26as_ugroup%3D*oracle* %26lr%3D%26num%3D50%26hl%3Den

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Alexander.Feinstein_at_mitchell1.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 14 2003 - 17:24:25 CDT