代码如下:表和字段都没有问题
CREATE OR REPLACE TRIGGER "WAPAPP"."TRG_TEST" BEFORE
INSERT ON "TEST_NEW" begin
insert into test_new2 values(:new.id,:new.blogid);
end;
CREATE OR REPLACE TRIGGER "WAPAPP"."TRG_TEST" BEFORE
INSERT ON "TEST_NEW" begin
insert into test_new2 values(:new.id,:new.blogid);
end;
BEFORE INSERT --要用 :NEW.ID必须指定行级触发器
FOR EACH ROW
ON "TEST_NEW"
begin
insert into test_new2 values(:new.id,:new.blogid);
end;
/
for each row