Database Trigger (All Types: Row level and Statement level triggers, Before and After
Triggers).
Write a database trigger on Library table. The System should keep track of the records that are being
updated or deleted. The old value of updated or deleted records should be added in Library_Audit
table.
Note: Instructor will Frame the problem statement for writing PL/SQL block for all types of Triggers
in line with above statement.
[Link]
delimiter $
create trigger t1 after insert on s1 for each row
begin
insert into s2 values([Link],[Link]);
end;
delimiter ;
delimiter $
create trigger t2 after update on s1 for each row
begin
insert into s2 values([Link],[Link]);
end;
delimiter ;
delimiter $
create trigger t3 after delete on s1 for each row
begin
insert into s2 values([Link],[Link]);
end;
delimiter ;
delimiter $
create trigger t4 before insert on s1 for each row
begin
set [Link]=(new.sub1+new.sub2)*100)/200;
end;
delimiter ;
delimiter $
create trigger t5 before insert on s1 for each row
begin
if [Link]=11 then set [Link]=1;
end if;
insert into s2 values([Link],[Link]);
end;
delimiter ;
delimiter $
create trigger p2 before update on s1 for each row
begin
if [Link]< 50 then
set [Link] = 49;
end if;
end;
delimiter ;
How to run:
1. Create table s1(roll, name), s2(roll, name), enter tuples into s1, s2 is empty.
2. Source [Link]
3. Select * from s2.(run single trigger)