Ram Ve

Greenhorn
+ Follow
since Jul 08, 2010
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Ram Ve

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








13 years ago