title: Getting Error "ORA-01732: data manipulation operation not legal on this view" while deleting from a table in oracle
body: <p>Same query running in Db2 , but in oracle it's giving error.
  Please help. thanks in advance.</p>
  
  <pre><code>delete from  (SELECT   
       EMP_ID,
       SAL,
       ROW_NUMBER() OVER (PARTITION BY EMP_ID ORDER BY SAL DESC) As RN
  FROM     FPM.FACT_PL_BS
  WHERE    MEASUREMENT_PERIOD_ID=20170811
  AND      SCENARIO_ID=1) A where RN&gt;1}
  </code></pre>