Team,
let us consider our basic scott.emp table to replicate the data for my current scenario.
On executing the below Delete stmt I get the error message as "ORA-01732: data manipulation operation not legal on this view"
Delete from (
select empno,ename,job,deptno,ROW_NUMBER( ) OVER (PARTITION BY deptno ORDER BY job DESC) AS rn from scott.emp a
) where rn>1
Any help most welcome.
Thanks !!