Cap17. TriggersMarch 25, 2010
1) Timp si data setata la executie
2) Triggers de insert
An INSERT trigger is a stored procedure you want the DBMS to execute either AFTER or INSTEAD OF executing an INSERT statement on a particular table or view .
3) Triggers de delete
A DELETE trigger is a stored procedure that the DBMS executes either after or instead of executing a DELETE statement on a specific table or view.
4) Triggers de update
An UPDATE trigger is a stored procedure that the DBMS executes either after or instead of executing an UPDATE statement on a specific table or view.
5) Trigger update pt.schimbare PK sau FK:
6) Cascade triggers
Because a trigger can execute INSERT, UPDATE, and DELETE statements, work performed by one trigger can cause the DBMS to activate another trigger, which may execute a statement that activates a third trigger, and so on. In short, a single triggering (INSERT, UPDATE, or DELETE) statement can cause the DBMS to activate a cascade of triggers, each trigger executing statements that activate other triggers.
7) Triggers referential integrity
8) Trigger pt. a trimite un mesaj e-mail