Hi,
I have the following clarification
I have an Employee Table
Employee
Name
Age
Gender
Last_Updated_User
Last_Updated_Time
are the columns in the Employee Table
I also have a generic audit table that I can use with the same format for my application
The Structure of the audit table would be
Column_Name
Old_Value
New_Value
Last_Updated_User
Last_Updated_Time
Expected Behaviour:
Insertion:
1. Whenever a new row has been inserted inside the master table, each column must be inserted as a row in the audit table with the old_value as null and new_value as insertion value
Updation:
1. Whenever a row has been updated inside the master table, each column that is updated only must be inserted as a row in the audit table with the old_value as old value and new_value as updated value
Deletion:
1. Whenever a row has been deleted from the master table, each column that is from the master table be inserted as a row in the audit table with the old_value as last value and new_value as null
How do I achieve this?
Please provide me with a Sample. Am new to Triggers and PL/SQL.
Thanks in Advance