Oracle Pl/SQL procedure to update values of one table to another

You do not need cursors to do this. If you have a foreign key relationship between the tables you can update on a key-preserved view of the two tables ...

stackoverflow.com