WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; spool CON_CONTRACT.log PROMPT PROMPT CREATING TABLE TRAIN_CONFIG PROMPT ============================ PROMPT WHENEVER SQLERROR CONTINUE DROP TABLE CON_CONTRACT; WHENEVER SQLERROR EXIT FAILURE ROLLBACK alter table hls_bp_master_credit_hd add (credit_status varchar2(100)); comment on column hls_bp_master_credit_hd.credit_status is '授信状态'; alter table hls_bp_master_credit_hd add (credit_total_amount_tmp number); comment on column hls_bp_master_credit_hd.credit_total_amount_tmp is '临时总额度'; alter table hls_bp_master_credit_hd add (CREDIT_DATE_FROM_TMP date); comment on column hls_bp_master_credit_hd.CREDIT_DATE_FROM_TMP is '临时授信时间从'; alter table hls_bp_master_credit_hd add (CREDIT_DATE_TO_TMP date); comment on column hls_bp_master_credit_hd.CREDIT_DATE_TO_TMP is '临时授信时间到'; SPOOL OFF EXIT