之前很多表增加很多相同的字段，一个一个添加太慢烦了，于是用了以下的方法
alter table t_xmlc_batch_out_head_bak add

(  SENDRECEIVEFLAG     VARCHAR2(1) default 0,

  SENDRECEIVEOPERATOR VARCHAR2(50),

  SENDRECEIVEDATE     DATE,

  DECLAREAPPLICANT    VARCHAR2(50),

  DECLAREDATE         DATE,

  DECLAREAPPROVEFLAG  VARCHAR2(1) default 0,

  DECLAREAPPROVEDATE  DATE

);

comment on column t_xmlc_batch_out_head_bak.SENDRECEIVEFLAG

  is '货物实际收发标志(0-未确认；1-已确认；)';

comment on column t_xmlc_batch_out_head_bak.SENDRECEIVEOPERATOR

  is '货物实际收发人    ';

comment on column t_xmlc_batch_out_head_bak.SENDRECEIVEDATE

  is '货物实际收发日期 ';

comment on column t_xmlc_batch_out_head_bak.DECLAREAPPLICANT

  is '货物实际申报申请人 ';

comment on column t_xmlc_batch_out_head_bak.DECLAREDATE

  is '货物实际申报日期 ';

comment on column t_xmlc_batch_out_head_bak.DECLAREAPPROVEFLAG

  is '货物实际申报审批标志';

comment on column t_xmlc_batch_out_head_bak.DECLAREAPPROVEDATE

  is '货物实际申报审批日期 ';

 update T_XMLC_BILL_HEAD_PRE set  DeclareApplicant='冯谊',DeclareApproveFlag=1,DeclareDate=to_date('2016/1/14 16:11:37','yyyy-MM-dd:hh24:mi:ss') where oid='ea1d5c38-d18f-45dd-8c1e-afd5a40ea93d';