Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table users (id number, first_name varchar2(10), last_name varchar2(10), age number);
create table users_history_changes (id number, first_name varchar2(10), last_name varchar2(10), age number, timestamp_changes timestamp);
create trigger users_trigger
before insert or update on users
for each row
begin
  if inserting then
    insert into users_history_changes (id, first_name, last_name, age, timestamp_changes)
    values (:new.id, :new.first_name, :new.last_name, :new.age, systimestamp);
  end if;
  
  if updating ('FIRST_NAME') then
    insert into users_history_changes (id, first_name, timestamp_changes)
    values (:new.id, :new.first_name, systimestamp);
  end if;
  if updating ('LAST_NAME') then
    insert into users_history_changes (id, last_name, timestamp_changes)
    values (:new.id, :new.last_name, systimestamp);
  end if;
  if updating ('AGE') then
    insert into users_history_changes (id, age, timestamp_changes)
    values (:new.id, :new.age, systimestamp);
  end if;
end;
/
insert into users
select 1, 'Raul', 'Peres', 25 from dual
union all select 2, 'Francis', 'Lotters', 40 from dual
union all select 3, 'Maria', 'Lopez', 39 from dual;
3 rows affected

update users set last_name = 'Felipes' where id = 1;
1 rows affected

update users set first_name = 'Pedro' where id = 1;
1 rows affected

update users set age = 30 where id = 1;
1 rows affected

update users set age = 41 where id = 2;
1 rows affected

update users set first_name = 'add', last_name = 'ddd', age = 2 where id = 3;
1 rows affected

select * from users_history_changes order by timestamp_changes;


ID
FIRST_NAME
LAST_NAME
AGE
TIMESTAMP_CHANGES


1
Raul
Peres
25
30-MAR-21 09.44.08.051893 AM

2
Francis
Lotters
40
30-MAR-21 09.44.08.052892 AM

3
Maria
Lopez
39
30-MAR-21 09.44.08.052998 AM

1
null
Felipes
null
30-MAR-21 09.44.08.064562 AM

1
Pedro
null
null
30-MAR-21 09.44.08.067683 AM

1
null
null
30
30-MAR-21 09.44.08.071298 AM

2
null
null
41
30-MAR-21 09.44.08.073368 AM

3
add
null
null
30-MAR-21 09.44.08.075428 AM

3
null
ddd
null
30-MAR-21 09.44.08.075518 AM

3
null
null
2
30-MAR-21 09.44.08.076059 AM

ID	FIRST_NAME	LAST_NAME	AGE	TIMESTAMP_CHANGES
1	Raul	Peres	25	30-MAR-21 09.44.08.051893 AM
2	Francis	Lotters	40	30-MAR-21 09.44.08.052892 AM
3	Maria	Lopez	39	30-MAR-21 09.44.08.052998 AM
1	null	Felipes	null	30-MAR-21 09.44.08.064562 AM
1	Pedro	null	null	30-MAR-21 09.44.08.067683 AM
1	null	null	30	30-MAR-21 09.44.08.071298 AM
2	null	null	41	30-MAR-21 09.44.08.073368 AM
3	add	null	null	30-MAR-21 09.44.08.075428 AM
3	null	ddd	null	30-MAR-21 09.44.08.075518 AM
3	null	null	2	30-MAR-21 09.44.08.076059 AM