create or replace trigger insert_users
after insert on users
for each row
begin
insert into cc(id,name )values(:new.id,:new.name);
end;
我验证了下,可以插入啊。
insert into users(id,name,age)values(2,null,24);
create or replace TRIGGER tri_test
after insert on testa
referencing old as old new as new
for each row
begin
insert into test values(:new.id, :new.name, :new.sex);
end;