getting error :
ERROR: ORACLE prepare error: ORA-00923: FROM keyword not found where expected. SQL statement: SELECT DISTINCT '01JAN2018'd as Month, COUNT(CASE WHEN (CHARGE_CODE='AVBAL') THEN CHARGE_CODE END) AS AVBAL_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE='AVBAL') THEN FORACID END) AS AVBAL_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE='AVBAL') THEN APPROPRIATED END) AS AVBAL_AMT_REC, COUNT(CASE WHEN (CHARGE_CODE='CCNNA') THEN CHARGE_CODE END) AS CCNNA_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE='CCNNA') THEN FORACID END) AS CCNNA_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE='CCNNA') THEN APPROPRIATED END) AS CCNNA_AMT_REC, COUNT(CASE WHEN (CHARGE_CODE='CHQRT') THEN CHARGE_CODE END) AS CHQRT_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE='CHQRT') THEN FORACID END) AS CHQRT_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE='CHQRT') THEN APPROPRIATED END) AS CHQRT_AMT_REC, COUNT(CASE WHEN (CHARGE_CODE NOT IN ('AVBAL','CCNNA','CHQRT')) THEN CHARGE_CODE END) AS OTHERS_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE NOT IN ('AVBAL','CCNNA','CHQRT')) THEN FORACID END) AS OTHERS_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE NOT IN('AVBAL','CCNNA','CHQRT')) THEN APPROPRIATED END) AS OTHERS_AMT_REC FROM table_name WHERE SCHM_TYPE='CAA' AND (RECOVER_DATE BETWEEN '08-2012' AND '08-2012').
... View more