分配的字节的数是一样的,实际的存储长度,以具体的数据为准; -- 你观察一下这个 create table test(c1 number,c2 number(18,2), c3 number(20,3));begin insert into test values(100,100,100); insert into test values(1.001,1.001,1.001); insert into test values(1.01,1.01,1.01); end; /select dump(c1) c1, dump(c2) c2 , dump(c3) c3 from test;drop table test purge;
-- 你观察一下这个 create table test(c1 number,c2 number(18,2), c3 number(20,3));begin
insert into test values(100,100,100);
insert into test values(1.001,1.001,1.001);
insert into test values(1.01,1.01,1.01);
end;
/select dump(c1) c1, dump(c2) c2 , dump(c3) c3 from test;drop table test purge;