oracle 的行级触发器

create or replace trigger tri_insertAcceptList
after insert on STDOC.DEVELOPER
for each row
  DECLARE
   v_idvalues number;
   
begin
 STDOC.PROCKEYCODE(v_idvalues);
 INSERT INTO ACCEPTLIST(KEYCODE,Acceptdate) VALUES(v_idvalues,SYSDATE);
end;

 

posted @ 2015-02-16 15:54  洛晨随风  阅读(721)  评论(0编辑  收藏  举报