商业智能在传统邮政业务中的应用(090705终).pptVIP

* * * * * * --12:40 CREATE VOLATILE TABLE TMP_Mail_NUM AS ( sel Mail_NUM from ems_pview.vw_evt_mail_clct where CLCT_Date between date 2007-07-01 and date 2007-09-30 and REC_AVAIL_Flag = 1 group by Mail_NUM having count(*) = 1 ) WITH DATA PRIMARY index(Mail_NUM) ON COMMIT PRESERVE ROWS; CREATE VOLATILE TABLE TMP_Mail_CUST AS ( sel Sender_CUST_Code, CLCT_Date, CLCT_Bureau_ORG_Code ORG_Code, Mail_NUM, DLV_AREA_Code, Mail_Kind_