Example: Row Level Trigger

CREATE TRIGGER NoLowerPrices

INSTEAD OF UPDATE OF price ON Product

REFERENCING

OLD AS OldTuple

NEW AS NewTuple

WHEN (OldTuple.price < NewTuple.price)

UPDATE Product

SET price = NewTuple.price

WHERE name = NewTuple.name

FOR EACH ROW

Previous slide

Next slide

Back to first slide

View graphic version