Triggers Syntax

Triggers Syntax:-

Set Serveroutput on;

Ed filename.sql

Create or Replace Trigger t1 after insert or delete or update on students for each row

Declare

Op varchar(20);

Begin

If inserting then

Op:=’inserted’;

End if;

If deleteing then

Op:=’deleted’;

End if;

If updating then

Op:=’updated’;

End if;

Insert into log values(Sysdate,op,’Students’);

Dbms_output.put_line(’success’);

End;

/