--创建测试数据
create table employees_act as
select employee_id,first_name,last_name from hr.employees where employee_id in(102,105,112,118,119,205) order by employee_id;
create table employees_new as
select employee_id,first_name,last_name from hr.employees where employee_id in(101,105,112,171,201) order by employee_id;
SQL> select * from employees_new;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
101 Neena Kochhar
105 David Austin
112 Jose Manuel Urman
171 William Smith
201 Michael Hartstein
SQL> select * from employees_act;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- ---------------
create table employees_act as
select employee_id,first_name,last_name from hr.employees where employee_id in(102,105,112,118,119,205) order by employee_id;
create table employees_new as
select employee_id,first_name,last_name from hr.employees where employee_id in(101,105,112,171,201) order by employee_id;
SQL> select * from employees_new;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
101 Neena Kochhar
105 David Austin
112 Jose Manuel Urman
171 William Smith
201 Michael Hartstein
SQL> select * from employees_act;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- ---------------