alter table tbname modify(colname default 'value');
alter table tbl MODIFY a number(5) default 0
SQL> alter table ta modify(n default 1);表已更改。SQL> select * from ta; ID NAME N --------- ---------- --------- 6 SQL> insert into ta(id) values(1);已创建 1 行。SQL> select * from ta; ID NAME N --------- ---------- --------- 6 1 1
--------- ---------- ---------
6
SQL> insert into ta(id) values(1);已创建 1 行。SQL> select * from ta; ID NAME N
--------- ---------- ---------
6
1 1