添加列:
alter table KJGL_SXS add (
JJLXR VARCHAR2(20),
JJLXDH VARCHAR2(20)
);
添加备注:
comment on column KJGL_SXS.JJLXR is '紧急联系人';
comment on column KJGL_SXS.JJLXDH is '紧急联系电话';
添加默认值:
alter table KJGL_SXS modify JJLXR default '测试';
添加列:
alter table KJGL_SXS add (
JJLXR VARCHAR2(20),
JJLXDH VARCHAR2(20)
);
添加备注:
comment on column KJGL_SXS.JJLXR is '紧急联系人';
comment on column KJGL_SXS.JJLXDH is '紧急联系电话';
添加默认值:
alter table KJGL_SXS modify JJLXR default '测试';