我做个实验,供你参考SQL> create table tblTest(a number,b varchar2(10));Table created.SQL> insert into tblTest values(1,'aaa');1 row created.SQL> commit;Commit complete.SQL> insert into tblTest values(null,'bbb');1 row created.SQL> commit;Commit complete.SQL> alter table tblTest modify (a number default 0);Table altered.SQL> insert into tblTest(b) values('ccc');1 row created.SQL> commit;Commit complete.SQL> select * from tblTest; A B
---------- ----------
1 aaa
bbb
0 ccc
---------- ----------
1 aaa
bbb
0 ccc
表已创建。
SQL> alter table lhg modify k1 default 0;表已更改。SQL> insert into lhg values(null,'123');已创建 1 行。SQL> select * from lhg; K1 K2
---------- ------
123SQL> insert into lhg(k2) values('223');已创建 1 行。SQL> select * from lhg; K1 K2
---------- ------
123
0 223