HLS_BP_MASTER_CREDIT_HD.sql 928 Bytes
Newer Older
stone's avatar
stone committed
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
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