CREATE OR REPLACE TRIGGER lease_til_expired
  after INSERT OR UPDATE ON zuordnung
  FOR each ROW
DECLARE
  -- local variables here
BEGIN
  IF :NEW.Art = 0 THEN
    UPDATE Zuordnung SET lease_ende = sysdate WHERE Mitarbeiter_ID = :NEW.Mitarbeiter_ID;
END IF;
END lease_til_expired;