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 BEGIN alter table csh_payment_req_ln add (amount_vender number); alter table csh_payment_req_ln add (amount_agent number); alter table csh_payment_req_ln add (down_payment_rushoff number); ALTER TABLE csh_payment_req_ln ADD bp_bank_full_name VARCHAR2(2000); COMMENT ON COLUMN csh_payment_req_ln.bp_bank_full_name IS '应付我司开户行'; ALTER TABLE csh_payment_req_ln ADD vender_bank_full_name VARCHAR2(2000); COMMENT ON COLUMN csh_payment_req_ln.vender_bank_full_name IS '厂商开户行'; ALTER TABLE csh_payment_req_ln ADD vender_bank_account_name VARCHAR2(2000); COMMENT ON COLUMN csh_payment_req_ln.vender_bank_account_name IS '厂商账户名'; ALTER TABLE csh_payment_req_ln ADD vender_bank_account_number VARCHAR2(2000); COMMENT ON COLUMN csh_payment_req_ln.vender_bank_account_number IS '厂商账户号'; comment on column csh_payment_req_ln.amount_vender is '应付厂商金额'; comment on column csh_payment_req_ln.amount_agent is '应付代理店金额'; comment on column csh_payment_req_ln.down_payment_rushoff is '首付款抵冲金额'; end; SPOOL OFF EXIT