title: PL/SQL loop through cursor
body: <p>My problem isn't overly complicated, but I am a newbie to PL/SQL.</p>
  
  <p>I need to make a selection from a COMPANIES table based on certain conditions. I then need to loop through these and convert some of the fields into a different format (I have created functions for this), and finally use this converted version to join to a reference table to get the score variable I need. So basically:</p>
  
  <pre><code>select id, total_empts, bank from COMPANIES where turnover &gt; 100000 
  </code></pre>
  
  <p>loop through this selection</p>
  
  <pre><code>insert into MY_TABLE (select score from REF where conversion_func(MY_CURSOR.total_emps) =  REF.total_emps)
  </code></pre>
  
  <p>This is basically what I am looking to do. It's slightly more complicated but I'm just looking for the basics and how to approach it to get me started!</p>