Categories
database-cursor loops plsql sql

PL/SQL loop through cursor

My problem isn’t overly complicated, but I am a newbie to PL/SQL.

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:

select id, total_empts, bank from COMPANIES where turnover > 100000 

loop through this selection

insert into MY_TABLE (select score from REF where conversion_func(MY_CURSOR.total_emps) =  REF.total_emps)

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!