Bad Things Can Happen

CREATE TRIGGER Bad-trigger

AFTER UPDATE OF price IN Product

REFERENCING OLD AS OldTuple

NEW AS NewTuple

WHEN (NewTuple.price > 50)

UPDATE Product

SET price = NewTuple.price * 2

WHERE name = NewTuple.name

FOR EACH ROW

Previous slide

Next slide

Back to first slide

View graphic version