文件名称:jiaoben
介绍说明－－下载内容均来自于网络，请自行研究使用
create or replace trigger delete_emp
after delete on departments
for each row
begin
delete from employees
where departmentid=:old.departmentid
end delete_emp
-create or replace trigger delete_emp after delete on departments for each row begin delete from employees where departmentid =: old.departmentid end delete_emp
after delete on departments
for each row
begin
delete from employees
where departmentid=:old.departmentid
end delete_emp
-create or replace trigger delete_emp after delete on departments for each row begin delete from employees where departmentid =: old.departmentid end delete_emp
(系统自动生成,下载前可以参看下载内容)
下载文件列表
实验脚本\闪回删除.txt
........\实验六示范.txt
........\实验用脚本文件new.txt
........\数据泵.txt
........\3.sql
........\5.txt
........\6.txt
........\7.txt
........\闪回表.txt
........\4.sql
实验脚本
........\实验六示范.txt
........\实验用脚本文件new.txt
........\数据泵.txt
........\3.sql
........\5.txt
........\6.txt
........\7.txt
........\闪回表.txt
........\4.sql
实验脚本