機械翻訳について

ZCH_CLNS_RSLT_STATUS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: ZCH

• オブジェクト・タイプ: VIEW

列

名前
DATA_MGMT_BATCH_ID TOTAL NO_OF_CLEANSED NO_OF_VERIFIED NO_OF_SKIPPED NO_OF_FAILED COUNT_STAR CT_TOTAL CT_OF_CLEANSED CT_OF_VERIFIED CT_OF_SKIPPED CT_OF_FAILED

問合せ

SQL_Statement

SELECT ZCR.DATA_MGMT_BATCH_ID, SUM(DECODE(ZCR.PROCESS_STATUS_CODE, NULL, 0, 1)) Total, SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'CLEANSED', 1, 0)) no_of_Cleansed, SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'VERIFIED', 1, 0)) no_of_Verified, SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'SKIPPED', 1, 0)) no_of_Skipped, SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'FAILED', 1, 0)) no_of_Failed, COUNT(*) COUNT_STAR, COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, NULL, 0, 1)) ct_Total, COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'CLEANSED', 1, 0)) ct_of_Cleansed, COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'VERIFIED', 1, 0)) ct_of_Verified, COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'SKIPPED', 1, 0)) ct_of_Skipped, COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'FAILED', 1, 0)) ct_of_Failed FROM FUSION.ZCH_CLNS_LOC_RESULTS ZCR GROUP BY ZCR.DATA_MGMT_BATCH_ID