PL/SQL Using Cursor Loop to insert values

Hello expert,

In previous question titled 'DECLARE CURSOR IS SELECT BEGIN'
The Cursor/Loop form was used to display a list of names and Contact IDs

Informative but not too useful.

In this question, more complex, there are attached texts to create three
tables
TMP_SOURCE_180615 has fields Contact_ID, FirstName and LastName

TMP_SOURCE_180617 has fields Contact_ID, Contact_Phone, FirstName and LastName

TMP_SOURCE_180618 has fields Contact_ID, LastName, and Contact_Phone

PS File names too long for display. Have truncated the names to the last six digits..

Ususally a script is attempted before asking a question because I don't
believe in just asking a completely open ended question like 'How do I do this?'

But have tried a couple of things and it is obvious that I am not even close.

However within the context of the script marked 'Declare Cursor TMP_SOURCE_180615'
copied herewith below what is the approach and tactic:

Where the Contact_ID is a certain value in TMP_SOURCE_180615
Fetch the CONTACT_PHONE that has that CONTACT_ID value from TMP_SOURCE_180617
and insert the CONTACT_PHONE value that matches the Contact_ID in TMP_SOURCE_180618
in the matching CONTACT_Phone field.

Again would like to make question more specific but am in uncharted waters and cannot
find a tutorial that addresses this issue.

Will double point on answer.

Allen in Dallas

---- Declare Cursor TMP_SOURCE_180615 ------
SET SERVEROUTPUT ON
DECLARE
      CURSOR cur_name
      IS
            SELECT
                  CONTACT_ID, FIRST_NAME, LAST_NAME
            FROM
                  TMP_SOURCE_180615
            ORDER BY
                  CONTACT_ID;
BEGIN
      FOR TMP_SOURCE_180615 IN cur_name
      LOOP
            DBMS_OUTPUT.PUT_LINE(TMP_SOURCE_180615.CONTACT_ID ||': '|| TMP_SOURCE_180615.FIRST_NAME || ' ' || TMP_SOURCE_180615.LAST_NAME);
      END LOOP;
END
180615.txt
180617.txt
180618.txt
180615.txt