行级触发器记录条件是否满足.
CREATE OR REPLACE TRIGGER aaaa_test
before Update
ON aaaa REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
if :NEW.no='10' then
aaaa_package.dele_bool:='1';
end if;
END;
语句级执行.
CREATE OR REPLACE TRIGGER aaaa_test1
after Update
ON aaaa REFERENCING NEW AS NEW OLD AS OLD
BEGIN
if aaaa_package.dele_bool='1' then
delete aaaa where no='10';
aaaa_package.dele_bool:='0';
end if;
END;
包体记录判断条件
CREATE OR REPLACE package aaaa_package
IS
v_deleteID aaaa.no%type;
dele_bool char(1):='0';
end aaaa_package;
/