4 Replies Latest reply on Feb 5, 2014 1:38 AM by Partha Sarathy S

    on ORA-00933: SQL command not properly ended in Oracle SQL Developer

    023fa390-4e3f-4b7e-aef4-b0cb7f421a19

      hello!!

      when I try to perform the following query returns me this error:

       

      SELECT PERSONA, ENERO,FEBRERO,MARZO,ABRIL

      FROM ( SELECT PERSONA,MES,MONTO FROM EJEMPLO) AS TablaDato

      Pivot

      (

      sum(monto)

      For mes IN (ENERO,FEBRERO,MARZO,ABRIL)

      ) AS PIVOTABLE;

       

      when using the "AS" ERROR APPEARS

       

      Someone knows why??????