Trigger for comparing an employee's salary with that his or her supervisor.
Explain why this Trigger is not work.
CREATE TRIGGER INFORM_SUPERVISOR1
BEFORE INSERT OR UPDATE OF SALARY, SUPERVISOR_SSN ON EMPLOYEE
FOR EACH ROW
(NEW.SALARY > (SELECT SALARY FROM EMPLOYEE
Trigger in Oracle is modeled.