fff

BEGIN
   INSERT INTO gimmodfac_trace
               (session_id, operat_time, operat_by, machine, ip_address,
                run_program)
      SELECT audsid, SYSDATE, sys.login_user, machine,
             SYS_CONTEXT ('USERENV', 'IP_ADDRESS'), program
        FROM v$session
       WHERE audsid = USERENV ('SESSIONID');
END;

 

CREATE OR REPLACE TRIGGER TR_COPY_DATA
BEFORE DELETE ON A
FOR EACH ROW
BEGIN
INSERT INTO LOGA(A的字段1,A的字段2,A的字段3,delete_id,DELETE_TIME)
VALUES(:old.A的字段1,:old.A的字段2,:old.A的字段3,USER,SYSDATE)
;

INSERT INTO LOGB SELECT B.* FROM A,B WHERE A.*** = B.***
;

END TR_COPY_DATA ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14876437/viewspace-611083/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14876437/viewspace-611083/