CREATE OR REPLACE TRIGGER nr2
BEFORE UPDATE OF salariul ON angajati
FOR EACH ROW
DECLARE
istoric NUMBER := 0
BEGIN
SELECT COUNT(id_angajat) INTO istoric FROM istoric_functii WHERE id_angajat = :OLD.id_angajat;
IF istoric > 2 THEN raise_application_error( -20001, ‘A schimbat mai mult de 2 functii’);
END IF;
END;

CREATE OR REPLACE TRIGGER nr1
BEFORE UPDATE OF salariul ON angajati
FOR EACH ROW
DECLARE
istoric NUMBER := 0
BEGIN
SELECT COUNT(id_comanda) FROM comenzi WHERE id_angajat = :OLD.id_angajat;
IF istoric < 3 THEN raise_application_error( -20002, ‘A intermediat mai putin de 3 comenzi);
END IF;
END;