title: How to delete rows from a cursor with criteria from another cursor?
body: <p>I have 2 cursors that have a unique number that connects each other, say Student_ID.</p>
  
  <p>If there is same Student_ID found in the first cursor, I have to delete it from the second cursor.</p>
  
  <p>I found something like this but don't really understand how it goes:</p>
  
  <pre><code>open c1;  
  fetch c1 into cnumber;
  
  if c1%notfound then
     cnumber := 9999;
  
  else
     DELETE FROM courses_tbl
       WHERE CURRENT OF c1;
  
     COMMIT;
  </code></pre>
  
  <p>This is my first time doing Oracle PL/SQL.</p>