title: how to write loop in pl/sql that goes over numbers
body: <p>I want to write a loop that iterates over numbers <code>105 102 19 17 101 16 106 107</code></p>
  
  <p>for each iteration I want to plug the number in a query and insert it into a table. </p>
  
  <p>pseudo:</p>
  
  <pre><code>LOOP (105 102 19 17 101 16 106 107)
     FETCH select * from some_table where value=current_iteration_index --105..etc.
     INTO my_rec_type
  
  END LOOP;
  </code></pre>