shell调用户sqlplus与dbtool
`shell调用户sqlplus与dbtool
sqlplus dbtool自动登录脚本
分类： Shell linux MS SQL/Oracle/MySql 2010-11-01 19:46 60人阅读 评论(0) 收藏 举报
shell中调用sqlplus
sqlplus -s user/pwd@datebase<
spool b.txt
select * from a;
spool off
exit
EOF
cat b.txt|tr -d ''>b.txt
shell中调用dbtool
/dxyyt/kefu/dbtool cxtyd_rw/pwd@gdsm2 -f[$sqldir] afljk 1>/dev/null 2>&1
dbtool user/password@usid sql="${proc01};${proc02};${proc03};" dbtool_password>>/dev/null 2>&1
vi FShscAudit_out_data.sh
!/usr/bin/sh
. /home/ngboss/.profile
cd /usr1/kefu/zjy/fshsc
rm -rf .
dbfs <<EOF
CRM校验数据：
select sysdate from dual;
unload to FS_HSC_CU_GROUP_SIcrm.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SIcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_CU_CUSTOMERcrm.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_CA_ACCOUNTcrm.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
unload to FS_HSC_SUBS_SUBSCRIBERcrm.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_CA_CREDITcrm.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDITcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_CA_BILLMAILcrm.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_CA_SETTLETYPEcrm.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_BILLMAILcrm.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_RELATIONcrm.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATIONcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
unload to FS_HSC_SUBS_PAYPLANcrm.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLANcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_PAYBEHALFcrm.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALFcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_FORBIDcrm.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBIDcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_PRODUCTcrm.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_SUBS_PRODATTRcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_SUBS_SERVICEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_SUBS_RESOURCEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_CU_BINDNUMcrm.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_PR_MOBIMEIRELAcrm.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELAcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
unload to FS_HSC_CU_GROUPcrm.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUPcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_CU_GROUPMEMcrm.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_MK_CUSTMAILBILLcrm.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILLcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_GROUP_SUBSCRIBERcrm.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_GROUP_MEMBERcrm.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE from HSC_GROUP_MEMBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
HSC校验数据
select sysdate from dual;
unload to FS_HSC_CU_GROUP_SIhsc.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SI where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_CU_CUSTOMERhsc.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_CA_ACCOUNThsc.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
unload to FS_HSC_SUBS_SUBSCRIBERhsc.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_CA_CREDIThsc.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDIT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_CA_BILLMAILhsc.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_CA_SETTLETYPEhsc.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPE where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_BILLMAILhsc.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_RELATIONhsc.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATION where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
unload to FS_HSC_SUBS_PAYPLANhsc.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLAN where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_PAYBEHALFhsc.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALF where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_FORBIDhsc.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBID where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_SUBS_PRODUCThsc.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_SUBS_PRODATTRhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_SUBS_SERVICEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_SUBS_RESOURCEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_CU_BINDNUMhsc.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_PR_MOBIMEIRELAhsc.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELA where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
unload to FS_HSC_CU_GROUPhsc.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUP where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_CU_GROUPMEMhsc.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to FS_HSC_MK_CUSTMAILBILLhsc.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to FS_HSC_GROUP_SUBSCRIBERhsc.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to FS_HSC_GROUP_MEMBERhsc.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE FROM HSC_GROUP_MEMBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
exit
EOF
vi ZShscAudit_out_data.sh
!/usr/bin/sh
. /home/ngboss/.profile
cd /usr1/kefu/zjy/zshsc
rm -rf .
dbzs <<EOF
CRM校验数据：
select sysdate from dual;
unload to ZS_HSC_CU_GROUP_SIcrm.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SIcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_CU_CUSTOMERcrm.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_CA_ACCOUNTcrm.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
unload to ZS_HSC_SUBS_SUBSCRIBERcrm.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_CA_CREDITcrm.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDITcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_CA_BILLMAILcrm.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_CA_SETTLETYPEcrm.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_BILLMAILcrm.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_RELATIONcrm.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATIONcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
unload to ZS_HSC_SUBS_PAYPLANcrm.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLANcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_PAYBEHALFcrm.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALFcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_FORBIDcrm.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBIDcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_PRODUCTcrm.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_SUBS_PRODATTRcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_SUBS_SERVICEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_SUBS_RESOURCEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_CU_BINDNUMcrm.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_PR_MOBIMEIRELAcrm.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELAcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
unload to ZS_HSC_CU_GROUPcrm.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUPcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_CU_GROUPMEMcrm.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_MK_CUSTMAILBILLcrm.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILLcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_GROUP_SUBSCRIBERcrm.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_GROUP_MEMBERcrm.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE from HSC_GROUP_MEMBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
HSC校验数据
select sysdate from dual;
unload to ZS_HSC_CU_GROUP_SIhsc.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SI where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_CU_CUSTOMERhsc.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_CA_ACCOUNThsc.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
unload to ZS_HSC_SUBS_SUBSCRIBERhsc.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_CA_CREDIThsc.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDIT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_CA_BILLMAILhsc.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_CA_SETTLETYPEhsc.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPE where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_BILLMAILhsc.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_RELATIONhsc.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATION where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
unload to ZS_HSC_SUBS_PAYPLANhsc.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLAN where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_PAYBEHALFhsc.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALF where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_FORBIDhsc.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBID where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_SUBS_PRODUCThsc.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_SUBS_PRODATTRhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_SUBS_SERVICEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_SUBS_RESOURCEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_CU_BINDNUMhsc.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_PR_MOBIMEIRELAhsc.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELA where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
unload to ZS_HSC_CU_GROUPhsc.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUP where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_CU_GROUPMEMhsc.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
unload to ZS_HSC_MK_CUSTMAILBILLhsc.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
unload to ZS_HSC_GROUP_SUBSCRIBERhsc.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
unload to ZS_HSC_GROUP_MEMBERhsc.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE FROM HSC_GROUP_MEMBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
exit
EOF
/usr1/kefu/zjy/ZShscAudit_out_data.sh
################### 对账中山出数据程序 ########################
30 01 sh /usr1/kefu/zjy/ZShscAudit_out_data.sh >> ./ZShscAudit_out_data.log&
################### 对账佛山出数据程序 ########################
30 01 sh /usr1/kefu/zjy/FShscAudit_out_data.sh >> ./FShscAudit_out_data.log&
FS201209081001165181 FS201209081001165180 FS201209081001165177
ZS201209081001149989
`