RE: space taken up by number data types

[Igor Neyman]

Yes, T.Kyte is still right J Space is not reserved for NUMBER type, it is “variable length” column.  Amount of space occupied depends on particular number, which is stored in the column.   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: Tuesday, October 14, 2003 4:10 PM To: Multiple recipients of list ORACLE-L 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