ACP_INVOICE_LN.sql 832 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
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