CREATE TABLE MEMBER(
EID number,
ENAME VARCHAR2(30),
SAL number,
COMM number,
CHANGEDATE timestamp);
insert into member values(1,'James',2000,400,sysdate);
insert into member values(2,'Roy',3000,400,sysdate);
CREATE OR REPLACE TRIGGER MEMBER_UPDATE
BEFORE UPDATE OF SAL,COMM ON MEMBER
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
:NEW.CHANGEDATE:=sysdate;
END;
/
select * from member;
update member set sal=2500 where EID=1;
commit;
select * from member;
update member set ENAME='Sunny' where EID=2;
commit;
select * from member;