| RAISE_APPLICATION_ERROR(-20444,''''Sorry!Can''''''''t have two President.'''');
END IF;
END;
/
Q.编写一个数据库触发器，当任何时候某个部门从”dept”中删除时，该触发器将从”emp”表中删除该部门的所有雇员。
A.
CREATE OR REPLACE TRIGGER del_emp_deptno
BEFORE DELETE ON dept
FOR EACH ROW
BEGIN
DELETE FROM emp WHERE deptno=:OLD.deptno;
END;
/
(全文完)
上一页 [1] [2] [3] [4] | 
