Oracle deletes data according to Rownum

Recently, we have been porting SQL to Oracle. Since Oracle does not have the same Identity column as in SQL, we have encountered a lot of trouble, recently I encountered a stored procedure for deleting data based on the values of the auto-incrementing column. I found a method for half a day.

1. /* Procedure in Oracle */
3. -- Create a table. Because there is no identity in Oracle, remove the aid column and use rownum later.
4. Create table TempTable (
5. SearchID number (10, 0)
6. )
8. -- Delete the value of Rownum 5
10. Declare cursor tmp_cursorIsSelect rownum aid, searchid from TempTableForUpdate;
11. Tmp_record tmp_cursor % rowtype;
12. Begin
13. Open tmp_cursor;
14. Loop
15. Fetch tmp_cursor into tmp_record;
16. Exit when tmp_cursor % notfound;
18. If(Tmp_record.aid = 5) -- If rownum is 5
19. Then
20. Begin
21. Delete TempTable where current of tmp_cursor;
22. End;
23. EndIf;
24. End loop;
25. Close tmp_cursor;
26. Commit;
27. End;