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-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 14, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: space taken up by number data types
Tom's right.
It's been this way since at least 7.0.12
"Ryan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/14/2003 02:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
