create or replace trigger userinfo_insert
before insert on userinfo_qz
for each row
declare
begin
update userinfo_qz set updatetime = sysdate ;
end userinfo_insert;
sorry,我看成pb版了。
create or replace trigger trigername
before insert on tablename
for each row
declare
-- local variables here
begin
update tablename set updatetime = sysdate ;
end trigername;