How To Create After Trigger in PL/SQL?

1) S1:-

     NAME               ID        CNT DOJ

---------- ---------- ---------- ---------

Renuka           1218 9999999999 06-JUN-12

Krishna          1246 8888888888 07-JUL-12

Mansi            1210 8787878787 06-JUL-12

Sevali           1219 9898989898 08-JUN-12

Rachna           1234 9595959595 10-JUN-12

INPUT

create or replace trigger tri after update or delete on S1 for each row

declare

            renu varchar2(10);

begin

            if updating then

            renu:='update';

            end if;

            if deleting then

            renu:='delete';

            end if;

            insert into S2 values(:old.name,:old.id,:old.cnt,:old.doj,renu,sysdate);

end;

/

update S1 set name='Krupa' where name='Rachna';

delete from S1 where id=1246;

OUTPUT

Trigger created.

1 row updated.

1 row deleted.

Tables:-

1)   S1:-

NAME               ID        CNT DOJ

---------- ---------- ---------- ---------

Renuka           1218 9999999999 06-JUN-12

Mansi            1210 8787878787 06-JUL-12

Sevali           1219 9898989898 08-JUN-12

Krupa            1234 9595959595 10-JUN-12

2)   S2:-

NAME               ID        CNT DOJ       STATUS         SDATE

----------    ---------- --------- --------- ----------  --------

Rachna           1234 9595959595 10-JUN-12 update     04-APR-14

Krishna          1246 8888888888 07-JUL-12 delete     04-APR-14