Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE faktura ( 
  extnr        VARCHAR2(32), 
  fakturanr    NUMBER,
  fakturadate  DATE, 
  partner_name VARCHAR2(32)
);
CREATE OR REPLACE VIEW view_faktura AS 
SELECT extnr, fakturanr, fakturadate 
  FROM faktura;
CREATE TABLE log_table( 
  id             NUMBER GENERATED BY DEFAULT AS IDENTITY, 
  field_changed  VARCHAR2(30), 
  old_value      VARCHAR2(32), 
  new_value      VARCHAR2(32), 
  fakturanr      NUMBER,
  date_of_change DATE
);
create or replace trigger ChangeOnFaktura
  after update of extnr on faktura
  for each row
DECLARE
  PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
  insert into log_table (
    old_value,
    new_value,
    date_of_change,
    field_changed,
    fakturanr
  ) values (
    :OLD.extnr,
    :NEW.extnr,
    SYSDATE,
    'EXTNR',
    :NEW.fakturanr
  );
  COMMIT;
END;
/
INSERT INTO faktura(extnr, fakturanr, fakturadate, partner_name)
VALUES('1234/12', 1, DATE '2022-01-01', 'Global Sellers LTD');
1 rows affected

INSERT INTO faktura(extnr, fakturanr, fakturadate, partner_name)
VALUES('111', 2, DATE '2022-01-02', 'Thomas Limited');
1 rows affected

UPDATE view_faktura 
   SET extnr = '21' 
 WHERE fakturanr = 2
1 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
SELECT * FROM log_table;


ID
FIELD_CHANGED
OLD_VALUE
NEW_VALUE
FAKTURANR
DATE_OF_CHANGE


1
EXTNR
111
21
2
2022-06-21 09:21:16