alter table YD_MER_LISTING add GOODS_COLUMN5NEW NUMBER(19,8);
update YD_MER_LISTING set GOODS_COLUMN5NEW=GOODS_COLUMN5;
commit;
alter table YD_MER_LISTING drop column GOODS_COLUMN5;
alter table YD_MER_LISTING rename column GOODS_COLUMN5NEW to GOODS_COLUMN5;
增加小数位数(ORA-01440 )
最新推荐文章于 2024-03-22 11:43:21 发布