title: PL/SQL Cursor FOR loop using FETCH
body: <p>I'm trying to help my friend with his Oracle homework and he has the following problem:</p>
  
  <p>Use a cursor FOR loop to retrieve the blog id, blog url and blog description if the blog id is less than 4 and place it in a cursor variable. Fetch and process each record and insert a row in the table log for each blog id returned.</p>
  
  <p>We're finding it hard to understand but we have the query:</p>
  
  <pre><code>DECLARE
      CURSOR blog_cursor IS SELECT * FROM blog;
  BEGIN
    FOR blog_item IN blog_cursor LOOP
      IF( blog_item.blog_id &gt; 4 ) THEN
        -- Insert a row in the "table log"
        INSERT INTO log( log_id, log_url, log_desc )
        VALUES( blog_item.blog_id, blog_item.blog_url, blog_item.blog_desc );
      END IF;
    END LOOP;
  END;
  /
  </code></pre>
  
  <p>Table:</p>
  
  <pre><code>blog
      blog_id
      blog_url
      blog_desc
  </code></pre>
  
  <p>The query does the job, but it doesn't use the FETCH keyword so we don't think it's technically right.  The question seems poorly written but how would you answer it using the FETCH keyword?  I'm new to PL/SQL but I have experience with SQL.</p>