For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
SQL> delete from temp 2 where lag(memno,1) over (order by memno)=memno; where lag(memno,1) over (order by memno)=memno * ERROR at line 2: ORA-30483: window functions are not allowed here