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;
原文：http://www.cnblogs.com/llcdbk/p/4294210.html