/*INSERT触发器*/
CREATE OR REPLACE TRIGGER 触发器名称
BEFORE INSERT
ON 表名
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
declare
nSeq number;
begin
-- todo
end;
/*update 触发器*/
create or replace trigger 触发器名称
after update of checked_mark on 表名
for each row
declare
username varchar2(20);
begin
if :old.checked_mark<>:new.checked_mark then
-- todo
end if;
end;
CREATE OR REPLACE TRIGGER 触发器名称
BEFORE UPDATE
ON 表名
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
WHEN (
old.checked_mark='N' and new.checked_mark='Y'
)
declare
ncount number;
begin
:new.check_date :=sysdate;
-- todo
end;
/*delete 触发器*/
CREATE OR REPLACE TRIGGER 触发器名称
BEFORE DELETE ON 表名
REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW
begin
-- todo
end ;