你怎么写的?
NULL值识别啊: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;测试时:
往testa里插入值为NULL的数据,也以同步写到test表里。
NULL值识别啊: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;测试时:
往testa里插入值为NULL的数据,也以同步写到test表里。
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);