A question about Trigger? HELP!!!

From: violin <violin_at_ms1.accmail.com.tw>
Date: Wed, 10 Jun 1998 03:21:43 GMT
Message-ID: <357dfb99.10768942_at_192.9.10.33>

 Hello,
[Quoted]  I want to create a trigger for log scott.emp,  and log table name is scott.emplog  

 The purpose is  

 Before insert into emp ,
 insert into emplog (empno_new,ename_new,job_new,date,user) values
(:new.empno,:new.ename,:new.job,SYSDATE,user);
 

 Before update or delete emp,
 insert into emplog (empno_old,ename_old,job_old,date,user) values
(:old.empno,:old.ename,:old.job,SYSDATE,user);

 How could I edit my trigger script for these purpose?  Could any give me some advice???
 Help!!!Thank you so muuuuuuch!!!

 Please Cc to: violin_at_ms1.accmail.com.tw,thank you again!! Received on Wed Jun 10 1998 - 05:21:43 CEST