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
-
stone authored08d424d9