WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool ACP_INVOICE_LN.log PROMPT PROMPT CREATING TABLE TRAIN_CONFIG PROMPT ============================ PROMPT WHENEVER SQLERROR CONTINUE DROP TABLE ACP_INVOICE_LN; WHENEVER SQLERROR EXIT FAILURE ROLLBACK alter table acp_invoice_ln add (CONTRACT_NAME varchar2(200)); comment on column acp_invoice_ln.CONTRACT_NAME is '合同名称'; alter table acp_invoice_ln add (BP_NAME varchar2(200)); comment on column acp_invoice_ln.BP_NAME is '客户名称'; alter table acp_invoice_ln add (CONTRACT_STATUS varchar2(30)); comment on column acp_invoice_ln.CONTRACT_STATUS is '合同状态'; alter table acp_invoice_ln add (CONFIRMATION_STATUS varchar2(30)); comment on column acp_invoice_ln.CONFIRMATION_STATUS is '确认状态'; SPOOL OFF EXIT