As Fred says,
you should ShowSomeEffort.
However, here is a tip: Use "INSERT...SELECT" to perform the SELECT and the INSERT in a single statement e.g.
You should be able to figure it out from here.
[Edited my reply after I spotted the fairly obvious fact that you are using Oracle PL/SQL - doh!]