Clase Miercoles 11-01-2012.

Triggers:

create table Person (age int); CREATE TRIGGER PersonCheckAgeAFTER INSERT OR UPDATE OF age ON PersonFOR
BEGIN
IF
RAISE_APPLICATION_ERROR(-
END
END; EACH ROW (:new.age < 0) THEN20000, 'no negative age allowed'); IF;insert

into person values (-20);