就Oracle而言，数据库触发器完成了这项工作。
（设置日期格式;您不必这样做，但它将帮助我们以我们想要的方式查看日期）

SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';

Session altered.

SQL> create table test
  2    (id         number generated always as identity,
  3     name       varchar2(10),
  4     dat_update date
  5    );

Table created.

SQL> create or replace trigger trg_biu_test
  2    before insert or update on test
  3    for each row
  4  begin
  5    :new.dat_update := sysdate;
  6  end;
  7  /

Trigger created.

让我们测试一下：

SQL> insert into test (name) values ('Little');

1 row created.

SQL> select * from test order by id;

        ID NAME       DAT_UPDATE
---------- ---------- -------------------
         1 Little     01.12.2022 20:22:03

SQL> insert into test (name) values ('Foot');

1 row created.

SQL> update test set name = 'Yasuda' where name = 'Little';

1 row updated.

SQL> select * from test order by id;

        ID NAME       DAT_UPDATE
---------- ---------- -------------------
         1 Yasuda     01.12.2022 20:22:33
         2 Foot       01.12.2022 20:22:19

SQL>