alter table db_compensation add ( AUDIT_FLAG VARCHAR2(6), AUDIT_USER VARCHAR2(30), AUDIT_TIME DATE ); 添加备注: comment on column db_compensation.AUDIT_FLAG is '月结审核标识: 1:审核, 0:未审核'; comment on column db_compensation.AUDIT_USER is '审核账号'; comment on column db_compensation.AUDIT_TIME is '审核时间'; 添加默认值: alter table db_compensation modify AUDIT_FLAG default '0';
添加表字段长度
alter table 表名 modify 字段名 varchar2(4000);