commit trigger

I need to to create a trigger in Oracle 8, that executes when a transaction commits.

The trigger will analyze data on logged changes made to specified tables during the transaction and remove redundant data. So if a row is updated, then deleted, only a record of the deletion is retained.

I know there is no 'on commit' trigger in Oracle, so is there any other way of doing it?

Thanks,
pasal Received on Wed Oct 17 2001 - 03:27:20 CDT