PL/SQL : How to load data from oracle table to table using PL/SQL script

Step 1: To create source execute the below table creation script and use insert statements for load data to Employee Source table.
Source Table creation
create table Employee(
  empno    number(4,0),
  ename    varchar2(10),
  job      varchar2(9),
  mgr      number(4,0),
  hiredate date,
  sal      number(7,2),
  comm     number(7,2),
  deptno   number(2,0),
  constraint pk_emp primary key (empno)
);
Insert Statements
insert into Employee values(7839, 'KING', 'PRESIDENT', null,to_date('17-11-1981','dd-mm-yyyy'),5000, null, 10);
insert into Employee values(7698, 'BLAKE', 'MANAGER', 7839,to_date('1-5-1981','dd-mm-yyyy'),2850, null, 30);
insert into Employee values(7782, 'CLARK', 'MANAGER', 7839,to_date('9-6-1981','dd-mm-yyyy'),2450, null, 10);
insert into Employee values(7566, 'JONES', 'MANAGER', 7839,to_date('2-4-1981','dd-mm-yyyy'),2975, null, 20);
insert into Employee values(7788, 'SCOTT', 'ANALYST', 7566,to_date('13-JUL-87','dd-mm-rr') - 85,3000, null, 20);
insert into Employee values(7902, 'FORD', 'ANALYST', 7566,to_date('3-12-1981','dd-mm-yyyy'),3000, null, 20);
insert into Employee values(7369, 'SMITH', 'CLERK', 7902,to_date('17-12-1980','dd-mm-yyyy'),800, null, 20);
insert into Employee values(7499, 'ALLEN', 'SALESMAN', 7698,to_date('20-2-1981','dd-mm-yyyy'),1600, 300, 30);
insert into Employee values(7521, 'WARD', 'SALESMAN', 7698,to_date('22-2-1981','dd-mm-yyyy'),1250, 500, 30);
insert into Employee values(7654, 'MARTIN', 'SALESMAN', 7698,to_date('28-9-1981','dd-mm-yyyy'),1250, 1400, 30);
insert into Employee values(7844, 'TURNER', 'SALESMAN', 7698,to_date('8-9-1981','dd-mm-yyyy'),1500, 0, 30);
insert into Employee values(7876, 'ADAMS', 'CLERK', 7788,to_date('13-JUL-87', 'dd-mm-rr') - 51,1100, null, 20);
insert into Employee values(7900, 'JAMES', 'CLERK', 7698,to_date('3-12-1981','dd-mm-yyyy'),950, null, 30);
insert into Employee values(7934, 'MILLER', 'CLERK', 7782,to_date('23-1-1982','dd-mm-yyyy'),1300, null, 10);
Once you execute the above scripts, Data will be avaiable as below.

Step 2:  Then create destination table (Employee_Desc) to load above datadata
Destination Table creation
create table Employee_Desc(
  empno    number(4,0),
  ename    varchar2(10),
  job      varchar2(9),
  mgr      number(4,0),
  hiredate date,
  sal      number(7,2),
  comm     number(7,2),
  deptno   number(2,0),
  constraint pk_emp_desc primary key (empno)
);
Step 3: Then create a procedure to load data as below.
Procedure creation script
CREATE PROCEDURE PROC_EMP_TG AS
BEGIN
insert into Employee_Desc(select * from EMPLOYEE);
COMMIT;
END PROC_EMP_TG;
Afterward, You can see the created procedure in the SQL developer.

Step 4: Then you can execute created procedure by command line or GUI.
Command line:

Data will be load as below.

GUI method:
Go to the Procedure section in the SQL developer and double click on the relevant procedure. then you can view as below.

In the Top corner you can see teh Run button. Click that button to execute teh procedure.

Click OK to execute the procedure.
Once completed you can see the screen as below.

Data will avaialabe as below in the destination table.