SCOTT_NO_DELETE_TRIGGER

CREATE OR REPLACE TRIGGER scott_no_delete
FOR DELETE ON emp
compound TRIGGER

BEFORE statement IS
BEGIN
  IF (sys.login_user = 'SCOTT') THEN
    raise_application_error (-20002, 'Scott darf nicht löschen!');

  END IF;
  END BEFORE statement;

END scott_no_delete;