SKINIDC@SKINPROD1> show user USER is "SKINIDC" SKINIDC@SKINPROD1> sta FINANCIAL_REPORT_MTD.sql SELECT SUM(CR_OFFERRED_REFERER) CR_OFFERRED_REFERER, SUM(DIS_REDEMPTIONS)DISCOUNT_REDEMPTIONS#,0 DISCOUNT_REDEMPTIONSSUM$,SUM(GIFT_REDEMPTIONS1) GIFT_REDEMPTIONS_PARTNER1#,SUM(GIFT_REDEMPTIONS2)GIFT_REDEMPTIONS_PARTNER2#,0 GIFT_REDEMPTIONS_PARTNER1$,0 GIFT_REDEMPTIONS_PARTNER2$FROM(SELECT CASE WHEN POINTS=1 THEN 1 ELSE 0 END CR_OFFERRED_REFERER , CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=1 THEN 1 ELSE 0 ENDDIS_REDEMPTIONS, CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=2 THEN 1 ELSE 0 ENDGIFT_REDEMPTIONS1, * ERROR at line 1: ORA-00923: FROM keyword not found where expected SELECT SUM(CR_OFFERRED_REFERER) CR_OFFERRED_REFERER, SUM(DIS_REDEMPTIONS)DISCOUNT_REDEMPTIONS#,0 DISCOUNT_REDEMPTIONSSUM$,SUM(GIFT_REDEMPTIONS1) GIFT_REDEMPTIONS_PARTNER1#,SUM(GIFT_REDEMPTIONS2)GIFT_REDEMPTIONS_PARTNER2#,0 GIFT_REDEMPTIONS_PARTNER1$,0 GIFT_REDEMPTIONS_PARTNER2$FROM(SELECT CASE WHEN POINTS=1 THEN 1 ELSE 0 END CR_OFFERRED_REFERER , CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=1 THEN 1 ELSE 0 ENDDIS_REDEMPTIONS, CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=2 THEN 1 ELSE 0 ENDGIFT_REDEMPTIONS1, * ERROR at line 1: ORA-00923: FROM keyword not found where expected SKINIDC@SKINPROD1> !ls SKINIDC@SKINPROD1> sta FINANCIAL_REPORT_YTD.sql SELECT SUM(CR_OFFERRED_REFERER) CR_OFFERRED_REFERER, SUM(DIS_REDEMPTIONS)DISCOUNT_REDEMPTIONS#,0 DISCOUNT_REDEMPTIONSSUM$,SUM(GIFT_REDEMPTIONS1) GIFT_REDEMPTIONS_PARTNER1#,SUM(GIFT_REDEMPTIONS2)GIFT_REDEMPTIONS_PARTNER2#,0 GIFT_REDEMPTIONS_PARTNER1$,0 GIFT_REDEMPTIONS_PARTNER2$FROM(SELECT CASE WHEN POINTS=1 THEN 1 ELSE 0 END CR_OFFERRED_REFERER , CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=1 THEN 1 ELSE 0 ENDDIS_REDEMPTIONS, CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=2 THEN 1 ELSE 0 ENDGIFT_REDEMPTIONS1, * ERROR at line 1: ORA-00923: FROM keyword not found where expected SELECT SUM(CR_OFFERRED_REFERER) CR_OFFERRED_REFERER, SUM(DIS_REDEMPTIONS)DISCOUNT_REDEMPTIONS#,0 DISCOUNT_REDEMPTIONSSUM$,SUM(GIFT_REDEMPTIONS1) GIFT_REDEMPTIONS_PARTNER1#,SUM(GIFT_REDEMPTIONS2)GIFT_REDEMPTIONS_PARTNER2#,0 GIFT_REDEMPTIONS_PARTNER1$,0 GIFT_REDEMPTIONS_PARTNER2$FROM(SELECT CASE WHEN POINTS=1 THEN 1 ELSE 0 END CR_OFFERRED_REFERER , CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=1 THEN 1 ELSE 0 ENDDIS_REDEMPTIONS, CASE WHEN POINTS=-1 AND DISCOUNT_TYPE=2 THEN 1 ELSE 0 ENDGIFT_REDEMPTIONS1, * ERROR at line 1: ORA-00923: FROM keyword not found where expected SKINIDC@SKINPROD1> spool off