create or replace trigger tri_insertUserMT
before insert or update on t_user
for each row
declare
-- local variables here
begin
select sysdate into :new.lastmodify from dual;
end tri_updateMT;
before insert or update on t_user
for each row
declare
-- local variables here
begin
select sysdate into :new.lastmodify from dual;
end tri_updateMT;
before insert or update on t_user
for each row
declare
-- local variables here
begin
select sysdate into :new.lastmodify from dual;
end tri_updateMT;正解!
before update on a
for each row
begin
:new.lastmodify:=sysdate;
end;
/