--create emp_target table
CREATE TABLE emp_target(
    employee_id   NUMBER(5,0),
    first_name    VARCHAR2(50 BYTE),
    last_name     VARCHAR2(50 BYTE),
    salary        NUMBER(6,0)
);

--insert some rows in emp_target table
SET DEFINE OFF;
Insert into EMP_TARGET (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (100,'Steven','King',22000);
Insert into EMP_TARGET (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (101,'Neena','Kochhar',15000);
Insert into EMP_TARGET (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (102,'Lex',null,15000);
Insert into EMP_TARGET (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (103,'Alexander','Hunold',7000);
Insert into EMP_TARGET (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (104,'Bruce','Ernst',4000);
/

--create emp_source table
CREATE TABLE emp_source(
    employee_id   NUMBER(5,0),
    first_name    VARCHAR2(50 BYTE),
    last_name     VARCHAR2(50 BYTE),
    salary        NUMBER(6,0)
);

--insert some rows in EMP_SOURCE table
SET DEFINE OFF;
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (100,'Steven','King',23000);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (101,'Neena','Kochhar',16000);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (102,'Lex','De Haan',16000);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (103,'Alexander','Hunold',8000);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (104,'Bruce','Ernst',5000);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (105,'David','Austin',3800);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (106,'Valli','Pataballa',3800);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (107,'Diana','Lorentz',3200);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (108,'Nancy','Greenberg',11008);
Insert into EMP_SOURCE (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY) values (109,'Daniel','Faviet',8000);
/