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 ;