create trigger del_reply
on Article
for delete
as
declare @id int
set @id=(select classID from deleted)
delete Reply where classID=@id
GO
这是一个删除的触发器,当删除 Article 表中的一条记录时,就把表 Reply 中 classID字段值和此记录的 classID值相同的记录全部删除掉
Create or replace trigger "Tri_name"
before insert on emp
for each row
declare
v_wage number ;
begin
select wage into v_wage from std where deptno= :new.staff_deptno;
if v_wage>=:new.wage then
Insert into emp1(staff_id,staff_wage) values(:new.staff_id,:new.staff_wage);
end if;
End Tri_name;
on Article
for delete
as
declare @id int
set @id=(select classID from deleted)
delete Reply where classID=@id
GO
这是一个删除的触发器,当删除 Article 表中的一条记录时,就把表 Reply 中 classID字段值和此记录的 classID值相同的记录全部删除掉
Create or replace trigger "Tri_name"
before insert on emp
for each row
declare
v_wage number ;
begin
select wage into v_wage from std where deptno= :new.staff_deptno;
if v_wage>=:new.wage then
Insert into emp1(staff_id,staff_wage) values(:new.staff_id,:new.staff_wage);
end if;
End Tri_name;