Oracle添加字段并加字段注释
alter table CHEDULE add SURGERY_CODE varchar2(64);
comment on column WM_SURGERY_SCHEDULE.DEPUTY1_SURGERY_CODE is ‘编码’;
alter table SCHEDULE add NAME varchar2(50);
comment on column WM_SURGERY_SCHEDULE.DEPUTY1_SURGERY_NAME is ‘名称’;
alter table SCHEDULE add DEPUTY2_SURGERY_CODE varchar2(50);
comment on column WM_SURGERY_SCHEDULE.DEPUTY2_SURGERY_CODE is ‘编码’;
alter table SCHEDULE add DEPUTY2_SURGERY_NAME varchar2(50);
comment on column WM_SURGERY_SCHEDULE.DEPUTY2_SURGERY_NAME is ‘名称’;