title: Oracle PL/SQL cursor update
body: <p>I'm using oracle. My SQL skills are very bad, I want to update information from a query that I have obtained through the use of a cursor, I've read about using the <code>WHERE CURRENT OF</code> statement, but I don't see how that can fit into my current code. Does anyone mind lending a helping hand? I want to allow a calling program to update a row in the cursor (I want to update the race location) returned by the query in my current code. Here's my code so far:</p>
  
  <pre><code>DECLARE 
  l_race_rec race%rowtype;
  
  CURSOR Query1
  IS
    SELECT * 
      FROM RACE 
     WHERE Race_Time='22-SEP-14 12.00.00.000000000'; 
  BEGIN
  OPEN Query1;
  LOOP
  FETCH query1 INTO l_race_rec;
  EXIT WHEN query1%notfound;
  
  dbms_output.put_line( l_race_rec.raceid || ', ' || l_race_rec.race_location || ', ' || 
  l_race_rec.race_type || ', ' || l_race_rec.race_time || ', ' || l_race_rec.sex || ', ' || 
  l_race_rec.minage || ', ' || l_race_rec.maxage );
  END LOOP;
  CLOSE Query1;    
  END;
  </code></pre>