Hello. I am new to Oracle. Using Oracle 9i on Windows 2000.
My question:
I need to audit a table and was wondering if someone could give me a trigger example. I need to copy all changes to table over to another table. ie. Copy deleted rows, inserted rows, updated rows, etc.
Let say that my table is called "money" and it has 3 columns(amount, type, color). I would like to copy all changes to "money_audit".
Thank you.