create or replace trigger A_trigger
before insert on A
for each row
begin
if :new.y=2 and :new.z=3
then :new.z:=8;
end if;
end;
就是说如果当前插入的记录y=2且z=3,则把插入记录的z改为8。
create or replace trigger test_trigger
after insert on test
declare
stmt varchar2(200);
begin
stmt := 'update A set z = 8 where y = 2 ';
EXECUTE IMMEDIATE stmt;
end test_trigger
create or replace trigger test_trigger
after insert on test
declare
stmt varchar2(200);
begin
stmt := 'update A set z = 8 where y = 2 ';
EXECUTE IMMEDIATE stmt;
end test_trigger