Re: numberic column size

Space occupied by a number column depends on the data stored in it and not on its definition:

v815> create table t (col1 number, col2 number(10), col3 number(15,3));
v815> insert into t values (0,0,0);
v815> insert into t values (1,1,1);
v815> insert into t values (100,100,100);
v815> insert into t values (257,257,257);
v815> insert into t values (123456,123456,123456);
v815> commit;
v815> select col1, vsize(col1), vsize(col2), vsize(col3) from t;

      COL1 VSIZE(COL1) VSIZE(COL2) VSIZE(COL3)
---------- ----------- ----------- -----------
         0           1           1           1
         1           2           2           2
       100           2           2           2
       257           3           3           3
    123456           4           4           4

5 rows selected.

--
Have a nice day
Michel


"Jun FAN" <jun-fj_fan_at_hp.com> a écrit dans le message news: 97i33q$bpb$1_at_ctss92.sgp.hp.com...


> Hi all,

>

> I was told that in Oracle the number(n) type column will occupy exactly the

> same number of n bytes, say number(6) will occupy 6 bytes and number(10,2)

> will be 10. Is it true? I can't find any hint in the oracle documents.

>

> Thanks for any explanation.

>

> Regards