DBAS32100 External Customer

Write a PL/SQL block that Extract all the data from ExternalCustomer table and load it to customer table. External customer and customer tables are not identical, so you will need to make some data transformation before you load the data to customer table. You need to use bulk collects and inserts

--------------------------------------------------------
-- DDL for Table CUSTOMER
--------------------------------------------------------

CREATE TABLE "CUSTOMER"
( "CUSTID" NUMBER,
"CUSTFIRSTNAME" VARCHAR2(12 BYTE),
"CUSTLASTNAME" VARCHAR2(12 BYTE),
"CUSTPHONENUM" VARCHAR2(18 BYTE)
);

--------------------------------------------------------
-- DDL for Table EXTERNALCUSTOMER
--------------------------------------------------------

CREATE TABLE "EXTERNALCUSTOMER"
( "CUSTOMERID" NUMBER,
"CUSTOMERNAME" VARCHAR2(24 BYTE),
"PHONENUMBER" VARCHAR2(14 BYTE)
);

--------------------------------------------------------
-- File created - Wednesday-July-18-2018
--------------------------------------------------------
Insert into EXTERNALCUSTOMER (CUSTOMERID,CUSTOMERNAME,PHONENUMBER) values (3,'Fedora Yopa','9052333424');
Insert into EXTERNALCUSTOMER (CUSTOMERID,CUSTOMERNAME,PHONENUMBER) values (4,'Ifeoma Smith','9052309424');
Insert into EXTERNALCUSTOMER (CUSTOMERID,CUSTOMERNAME,PHONENUMBER) values (1,'Rogers Waters','9058822222');
Insert into EXTERNALCUSTOMER (CUSTOMERID,CUSTOMERNAME,PHONENUMBER) values (2,'Stephanie Akujobi','9058822222');