create table t_test ( a int, b varchar2(100) )select * from t_testinsert into t_test values (1,'a') --修改字段默认值 alter table t_test modify b varchar2(10) default 'oracl'insert into t_test (a) values (3)A B ---------------------- ---------- 1 a 2 oracl 3 oracl
(
a int,
b varchar2(100)
)select * from t_testinsert into t_test values (1,'a')
--修改字段默认值
alter table t_test modify b varchar2(10) default 'oracl'insert into t_test (a) values (3)A B
---------------------- ----------
1 a
2 oracl
3 oracl