常用刪除觸發器代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】常用刪除觸發器

作者:Dezai.CN / 发布于2011/7/7/ 1001

<div>
--題目：<span style="font-family: 新細明體"></span><span style="font-family: SimSun">編寫一個數據庫觸發器，當任何時候某個部門的從</span><span style="font-family: 新細明體">dept</span><span style="font-family: SimSun">表中刪除的時</span><span style="font-family: 新細明體">,</span><span style="font-family: SimSun">該觸發器將從</span><span style="font-family: 新細明體">emp</span><span style="font-family: SimSun">表中刪除該部門的所有雇員。</span><span style="font-family: 新細明體"> </span><span style="font-family: 新細明體"></span>
CREATE OR REPLACE TRIGGER TRI_G1
BEFORE DELETE ON DEPT
FOR EACH ROW
BEGIN
DELETE FROM emp where DEPORTNO=:OLD.DEPT_NO;
END;

select * from emp
select * froM DEPT

INSERT INTO DEPT(DEPT_NO,DEPT_NAME) VALUES(3,'C')
BEGIN
<span>INSERT INTO EMP(EMPNO,ENAME,SALARY,COMM,DEPORTNO) VALUES(7986,'gangge',2001,35000,3);</span>
<span>INSERT INTO EMP(EMPNO,ENAME,SALARY,COMM,DEPORTNO) VALUES(7895,'WA',2100,25000,3);</span>
END;
DELETE FROM DEPT WHERE DEPT_NO=3
</div>

试试其它关键字

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)