How can one log the changes made to the data, in the oracle database tables ?

Question

i.e.how to log Insert, update and delete done by users on all the database tables.

Answer 1

Use triggers (Before insert/before update/before delete) and use autonomous transations in the procedure called in the trigger body.

Answer 2

Triggers is the way to do it, according to the changes you need to log (update, insert or delete)

Answer 3

we can't insert the diverse rows at a time. we are in a position to insert one row at a time. For putting diverse rows at a time. you may placed in writing the PL/sq. language or write the code with font-end device like java, vb, vc++ etc. that's it.