CREATE OR REPLACE TRIGGER "TABLET"."SETDATE" AFTER
INSERT
OR UPDATE ON "TABLET"."TEST" FOR EACH ROW
begin
update test
set d = sysdate
where a = new.a;
end ;
CREATE OR REPLACE TRIGGER "TABLET"."SETDATE" AFTER INSERT OR UPDATE ON "TABLET"."TEST" FOR EACH ROW begin update test set d = sysdate where a = new.a; end ; 我知道行级触发器不能修改触发表,可是这个问题有什么解决的办法吗? 我只是想在本条记录添加或修改的时候,隐藏增加一个时间信息
CREATE OR REPLACE TRIGGER SETDATE
BEFORE INSERT OR UPDATE
ON TEST
FOR EACH ROW
begin
if inserting then
:d :=sysdate;
elsif updating then
:d :=sysdate;
end if;
end;