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;