PL/SQL help with loops, method and explanation for Pl/SQL loops
I am new to PL/SQL and just can't seem to get the syntax right.
I am a PL/SQL newbie trying to create a package that will get a result (ID) from a query from two tables and then turn around and loop through the one or more records found and do an insert into a another based on
a select from the previous query. This is what I have now: