Auditing by Using a Trigger - 1









The interactions in this eCourse require Javascript to be enabled.



 

Auditing by
Using a Trigger: Part 1



previous|next







You may want to track the following while using
a business application:

Insertion of new data
Deletion of existing data
Modification of existing data

Application auditing is used if the changes to the table
columns need to be tracked and column values need to be stored for each
change. Oracle Database XE allows application auditing by using either
stored procedures or database triggers.
To create an audit system, you need to create an audit
table.This table is used to keep track of the changes to the data. When
the database trigger fires, records in the audit table are inserted.