Track what an SQL-query actually does (insert/update/delete) in Oracle
Is it possible to somehow log what a SQL-statement results in. For example:

    INSERT INTO bonus SELECT ename, job, sal, comm FROM emp
    WHERE comm > sal * 0.25;

How to get which rows that are acually inserted (or updated or deleted if it's another query), instead of just getting "5 rows inserted.". It would be especially nice if it's possible to get the change in SQL-form.
Track what an SQL-query actually does (insert/update/delete) in Oracle
===

Is it possible to somehow log what a SQL-statement results in. For example:

    INSERT INTO bonus SELECT ename, job, sal, comm FROM emp
    WHERE comm > sal * 0.25;

How to get which rows that are acually inserted (or updated or deleted if it's another query), instead of just getting "5 rows inserted.". It would be especially nice if it's possible to get the change in SQL-form.