음..

drop table aaa;
create table aaa (사번 number(12,2));
insert into aaa values(111.11);
alter table aaa modify (사번 number(12,4));

Alter table aaa  add (addrs varchar2(6));

insert into aaa values(111.11,'aaaaaa');

alter table aaa modify (addrs varchar2(7));
insert into aaa values(111.11,'aaaaaaa');

select * from aaa;

왜;;; number는 변경이 안될까요... 소숫점을 늘리려고 하는데....?????