SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> select * from dept_deleted;

no rows selected

SQL> get tr8
  1   CREATE OR REPLACE TRIGGER audit_dept AFTER DELETE  ON dept
  2          FOR EACH ROW
  3   DECLARE
  4     PRAGMA AUTONOMOUS_TRANSACTION;
  5   BEGIN
  6        INSERT INTO dept_deleted
  7        VALUES( :old.deptno, :old.dname, :old.loc, sysdate,user ,
  8                sys_context('userenv','ip_address'));
  9        COMMIT;
 10*  END;
SQL> /

Trigger created.

SQL> delete from dept;

4 rows deleted.

SQL> select * from dept_deleted;

    DEPTNO DNAME          LOC           DATED     OUSER                          MACHINE
---------- -------------- ------------- --------- ------------------------------ -------------------
        10 ACCOUNTING     NEW YORK      07-JUN-02 MAG                            192.168.1.104
        20 RESEARCH       DALLAS        07-JUN-02 MAG                            192.168.1.104
        30 SALES          CHICAGO       07-JUN-02 MAG                            192.168.1.104
        40 OPERATIONS     BOSTON        07-JUN-02 MAG                            192.168.1.104