Create Or Replace Trigger delete_dept
After delete on dept
For each row
begin
delete from type where type.deptname=:old.deptname;
delete from emp where emp.deptname=:old.deptname;
End delete_dept;
触发器 删除
最新推荐文章于 2022-04-02 15:53:59 发布
Create Or Replace Trigger delete_dept
After delete on dept
For each row
begin
delete from type where type.deptname=:old.deptname;
delete from emp where emp.deptname=:old.deptname;
End delete_dept;