日期:2014-05-16 浏览次数:21257 次
-- 如果当前表没有什么联线的操作的话,分步走试试: alter table ACCT_BILL add MN_AMOUNT NUMBER(10,2); alter table ACCT_BILL add GIVEN_AMOUNT NUMBER(10,2); alter table ACCT_BILL add BALANCE NUMBER(10,2); alter table ACCT_BILL add CASH NUMBER(10,2); update ACCT_BILL set MN_AMOUNT=0, GIVEN_AMOUNT=0, BALANCE=0, CASH=0; commit; alter table ACCT_BILL modify MN_AMOUNT default 0 not null; alter table ACCT_BILL modify GIVEN_AMOUNT default 0 not null; alter table ACCT_BILL modify BALANCE default 0 not null; alter table ACCT_BILLmodify CASH default 0 not null;