alter table DT060 add (TMP number(10,0));
update DT060 set TMP = TO_NUMBER(NVL(DI029547, '0')), DI029547 = null;
alter table DT060 modify (DI029547 number(10,0));
update DT060 set DI029547 = TMP;
alter table DT060 modify (DI029547 number(10,0) default 0 constraint DI029547_NOT_NULL not null);
alter table DT060 drop column TMP;

alter table DT818 add (TMP number(5,0));
update DT818 set TMP = TO_NUMBER(NVL(DI034406, '0')), DI034406 = null;
alter table DT818 modify (DI034406 number(5,0));
update DT818 set DI034406 = TMP;
alter table DT818 modify (DI034406 number(5,0) default 0 constraint DI034406_NOT_NULL not null);
alter table DT818 drop column TMP;

alter table DT885 add (TMP number(10,0));
update DT885 set TMP = TO_NUMBER(NVL(DI041325, '0')), DI041325 = null;
alter table DT885 modify (DI041325 number(10,0));
update DT885 set DI041325 = TMP;
alter table DT885 modify (DI041325 number(10,0) default 0 constraint DI041325_NOT_NULL not null);
alter table DT885 drop column TMP;
