title: Loop through an explicit cursor in Oracle
body: <p>How can I loop through an implicit cursor which is created, for example, from a query?</p>
  
  <p>Here is the sample code:</p>
  
  <pre><code>SERVEROUTPUT on;
  
  DECLARE      
    TYPE ref_cursor IS REF CURSOR;
    cur REF_CURSOR;
  
  BEGIN
    OPEN cur FOR 'SELECT i.item_no, 
                         i.item_descr 
                    FROM ITEMS i 
                   WHERE i.item_no in (1,2,3)';
  
    ... loop statement to print all item descriptions?
  
  END;
  </code></pre>