I'd appreciate if anyone could please tell me if there is a way to go up one row up in plsql cursor.
For eg:
cursor cr is select id from emp where rownum < 21;
for var in cr
loop
<here in the second iteration onwards, i would like to compare the current var.id with "id Value of previous row" >
end loop;
Any help in the logic can also be suggested.
Thanks for the help !
- AAG