Create table employees_log as
(
Select  employees.*
from employees
where employee_id = 12345000
);

Alter table employees_log
 Add (
        log_id Number(4),
        log_oper Varchar(50),
        log_time Date,
        log_user Varchar(50)
     );

Create Sequence emp_log_seq
increment by 1
start with 100
nocache;


Create or replace trigger emp_change_trig
  after update or delete
  on Employees_log
Declare
  vlog_id number(4) := emp_log_seq.nextval;
  vlog_action varchar(50);
  vlog_time date := sysdate;
  vlog_user varchar(50) := sys_context('userenv', 'current_user');
Begin
  if updating then
    vlog_action := 'Update';
  elsif deleting then
    vlog_action := 'Delete';
  end if;
  
  insert into Employees_log     
      values (:old.employee_id, :old.first_name, :old.last_name, :old.email, :old.phone_number, :old.hire_date, :old.job_id
                , :old.salary, :old.commission_pct, :old.manager_id, :old.department_id, vlog_id, vlog_action, vlog_time,   
vlog_user);
    
end;

referencing new as new old as old
for each row