I want to write a trigger that will show me the following:

who makes changes to a table(s) & when
which field(s) changed
the before and after values of said field(s)

my pl/sql skills are limited, and writing trigers is completely new to me.

Advice anyone?


thanks in advance