Hi guys, this is my first time using PL/SQL.
I have 2 cursors that have a unique number that connects each other, say Student_ID.
If there is same Student_ID found in the first cursor, I have to delete it from the second cursor.
I found something like this but don't really understand how it goes:
open c1;
fetch c1 into cnumber;
if c1%notfound then
cnumber := 9999;
else
DELETE FROM courses_tbl
WHERE CURRENT OF c1;
COMMIT;