17,140
社区成员




INSERT INTO T_ESHOP_MONTH
SELECT MON,
'qry_su',
DECODE(SUM(TOTAL), 0, 0, SUM(SU) / SUM(TOTAL)),
'www'
FROM (SELECT /*+parallel(t,10)*/
TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM') MON,
'qry_num' , COUNT(CASE
WHEN T.BUSI_RESULT = '0' THEN
1
END) SU,
COUNT(1) TOTAL
FROM ES_PUB_SYSTEMLOG T
WHERE T.OPER_TYPE = '0'
AND T.BIZ_BEGINDATE >= TO_DATE('20120601', 'YYYYMMDD')
AND T.BIZ_BEGINDATE < TO_DATE('20120701', 'YYYYMMDD')
GROUP BY TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM')
UNION ALL
SELECT /*+parallel(t,10)*/
TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM'),
'qry_num' , COUNT(CASE
WHEN T.BUSI_RESULT = '0' THEN
1
END) SU,
COUNT(1) TOTAL
FROM ES_PUB_SYSTEMLOGMM T
WHERE T.OPER_TYPE = '0'
AND T.BIZ_BEGINDATE >= TO_DATE('20120601', 'YYYYMMDD')
AND T.BIZ_BEGINDATE < TO_DATE('20120701', 'YYYYMMDD')
GROUP BY TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM'))
GROUP BY MON;
COMMIT;
INSERT INTO T_ESHOP_MONTH
SELECT MON,
'qry_su',
DECODE(SUM(TOTAL), 0, 0, SUM(SU) / SUM(TOTAL)),
'www'
FROM (SELECT /*+parallel(t,10)*/
TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM') MON,
'qry_num' , COUNT(CASE
WHEN T.BUSI_RESULT = '0' THEN
1
END) SU,
COUNT(1) TOTAL
FROM ES_PUB_SYSTEMLOG T
WHERE T.OPER_TYPE = '0'
AND T.BIZ_BEGINDATE >= V_MONTH_DATE--变量
AND T.BIZ_BEGINDATE < V_NMONTH --变量
GROUP BY TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM')
UNION ALL
SELECT /*+parallel(t,10)*/
TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM'),
'qry_num' , COUNT(CASE
WHEN T.BUSI_RESULT = '0' THEN
1
END) SU,
COUNT(1) TOTAL
FROM ES_PUB_SYSTEMLOGMM T
WHERE T.OPER_TYPE = '0'
AND T.BIZ_BEGINDATE >= V_MONTH_DATE--变量
AND T.BIZ_BEGINDATE < V_NMONTH --变量
GROUP BY TO_CHAR(T.BIZ_BEGINDATE, 'YYYYMM'))
GROUP BY MON;
COMMIT;