Oracle 11g Release 2

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

create table CUSTOMERS   ( id int, 
                     name varchar2(10), 
                     age int, 
                     address varchar2(100), 
                     salary int );
create table CUSTOMERS_D ( id int, 
                         name varchar2(10), 
                         age int, 
                         address varchar2(100), 
                         salary int, 
                       modified_time timestamp );
CREATE OR REPLACE TRIGGER CUST_TRIG 
  AFTER INSERT OR UPDATE ON CUSTOMERS 
FOR EACH ROW 
begin
   INSERT INTO CUSTOMERS_D
     (ID, NAME, AGE, ADDRESS, SALARY,modified_time ) 
       values (:new.ID,
       :new.NAME, 
       :new.AGE, 
       :new.ADDRESS, 
       :new.SALARY,
       systimestamp);
end ;
/
INSERT INTO CUSTOMERS (id,name,age,address,salary) values( 1,'JJ',40,'2nd cross',40000);
1 rows affected

update customers set salary = 50000 where id = 1;
1 rows affected

select * from customers_d;


ID
NAME
AGE
ADDRESS
SALARY
MODIFIED_TIME


1
JJ
40
2nd cross
40000
11-MAR-26 10.50.50.178010 AM

1
JJ
40
2nd cross
50000
11-MAR-26 10.50.50.200389 AM

ID	NAME	AGE	ADDRESS	SALARY	MODIFIED_TIME
1	JJ	40	2nd cross	40000	11-MAR-26 10.50.50.178010 AM
1	JJ	40	2nd cross	50000	11-MAR-26 10.50.50.200389 AM