oracle新增修改表字段+注释

--创建修改表示语句：
ALTER   TABLE  表名   ADD（字段名称  类型 DEFAULT 默认值）;--新增  
ALTER   TABLE   表名 MODIFY   要修改的字段  VARCHAR2（12）;--修改
comment on column 表名.字段 is '注释';--注释

--新增整改扣分单字段
alter table zjxydj_rectification
add (dc_codetz NVARCHAR2(60));
comment on column zjxydj_rectification.dc_codetz is '通报整改告知单单据号';

alter table zjxydj_rectification
add (PUBLICITY_START_DATE DATE);
comment on column zjxydj_rectification.PUBLICITY_START_DATE is '公示开始日期';

alter table zjxydj_rectification
add (PUBLICITY_END_DATE DATE);
comment on column zjxydj_rectification.PUBLICITY_END_DATE is '公示截至日期';

alter table zjxydj_rectification
add (EFFECTIVE_START_DATE DATE);
comment on column zjxydj_rectification.EFFECTIVE_START_DATE is '有效开始日期';

alter table zjxydj_rectification
add (EFFECTIVE_END_DATE DATE);
comment on column zjxydj_rectification.EFFECTIVE_END_DATE is '有效截至日期';

alter table zjxydj_rectification
add (ZGORGANISEID NVARCHAR2(50));
comment on column zjxydj_rectification.ZGORGANISEID is '主管单位ORGANISEID';



--新增奖励信息字段

alter table zjxydj_awardinformation
add (PUBLICITY_START_DATE DATE);
comment on column zjxydj_awardinformation.PUBLICITY_START_DATE is '公示开始日期';

alter table zjxydj_awardinformation
add (PUBLICITY_END_DATE DATE);
comment on column zjxydj_awardinformation.PUBLICITY_END_DATE is '公示截至日期';

alter table zjxydj_awardinformation
add (EFFECTIVE_START_DATE DATE);
comment on column zjxydj_awardinformation.EFFECTIVE_START_DATE is '有效开始日期';

alter table zjxydj_awardinformation
add (EFFECTIVE_END_DATE DATE);
comment on column zjxydj_awardinformation.EFFECTIVE_END_DATE is '有效截至日期';

alter table zjxydj_awardinformation
add (ZGORGANISEID NVARCHAR2(50));
comment on column zjxydj_awardinformation.ZGORGANISEID is '主管单位ORGANISEID';


--新增黑名单、行政处罚和违规扣分单信息字段
alter table 
add (ZGORGANISEID NVARCHAR2(50));
comment on column zjxydj_awardinformation.ZGORGANISEID is '主管单位ORGANISEID';


--新建表（整改通知单）                                                                                                                                                                   
create table ZJXYDJ_RECTIFICATION_TZ
(
  tz_id          NUMBER not null,
  dc_code        NVARCHAR2(50),
  dm_code        NVARCHAR2(50),
  input_emp      NVARCHAR2(50),
  input_dpm      NVARCHAR2(50),
  tz_state       NUMBER,
  tz_finish_date DATE,
  tz_send_date   DATE,
  tz_mark        NVARCHAR2(300),
  state          NVARCHAR2(50),
  update_emp     NVARCHAR2(50),
  update_time    DATE,
  zgorganiseid   NUMBER
)
tablespace ZJXYPJ
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table ZJXYDJ_RECTIFICATION_TZ
  is '地基基础检测通报批评整改信息通知单';
-- Add comments to the columns 
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_id
  is '通报批评ID';
comment on column ZJXYDJ_RECTIFICATION_TZ.dc_code
  is '单据号';
comment on column ZJXYDJ_RECTIFICATION_TZ.dm_code
  is '检测机构编号';
comment on column ZJXYDJ_RECTIFICATION_TZ.input_emp
  is '登记人';
comment on column ZJXYDJ_RECTIFICATION_TZ.input_dpm
  is '登记部门编号';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_state
  is '整改结果（1.已整改、2.未整改、3、整改中）';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_finish_date
  is '通报整改完成截至日期';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_send_date
  is '通报批评发出日期';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_mark
  is '备注';
comment on column ZJXYDJ_RECTIFICATION_TZ.state
  is '状态(填写/初审/待审核/已生效/退回/公示中/异议处理/已失效/已确认)';
comment on column ZJXYDJ_RECTIFICATION_TZ.update_emp
  is '修改人';
comment on column ZJXYDJ_RECTIFICATION_TZ.update_time
  is '修改时间';
comment on column ZJXYDJ_RECTIFICATION_TZ.zgorganiseid
  is '主管单位ORGANISEID';

  --创建修改表示语句：
ALTER   TABLE  表名   ADD（字段名称  类型 DEFAULT 默认值）;--新增  
ALTER   TABLE   表名 MODIFY   要修改的字段  VARCHAR2（12）;--修改
comment on column 表名.字段 is '注释';--注释