CREATE OR REPLACE TRIGGER DeleteMyView INSTEAD OF DELETE ON studentProf FOR EACH ROW
DECLARE name varchar (10);
BEGIN
  name := :old.student;
  DELETE FROM student where sName=name;
END;
.
