Re: Update with Triggers

create table a1 (dt date, num number);

CREATE OR REPLACE TRIGGER tr_a1

   BEFORE INSERT OR UPDATE
   ON a1
   FOR EACH ROW
BEGIN
   :NEW.dt := SYSDATE;
END;
/

insert into a1(num) values (1);

select * from a1;

DT                               NUM
10.10.2003 2:32:37      1

update a1 set num = num+1;

select * from a1;

DT                               NUM
10.10.2003 2:32:39      2