CREATE OR REPLACE TRIGGER table_Trigger
after delete or insert or update on table for each statement
begin
if delete then
--语句
end if;
if insert then
--语句
end if;
if update then
--语句
end if;
end;
/这样写的三合一的语句级触发器哪里错了??请更正,小弟急用,谢谢!!
after delete or insert or update on table for each statement
begin
if delete then
--语句
end if;
if insert then
--语句
end if;
if update then
--语句
end if;
end;
/这样写的三合一的语句级触发器哪里错了??请更正,小弟急用,谢谢!!
each row
after delete or insert or update on table for each statement
begin
if deleting then
--语句
end if;
if inserting then
--语句
end if;
if updating then
--语句
end if;
end;
oracle 分为行级别与语句别
CREATE OR REPLACE TRIGGER table_Trigger
after delete or insert or update on table
for each row
begin
if deleting then
--语句
end if;
if inserting then
--语句
end if;
if updating then
--语句
end if;
end;
/