database triggers

Trigger created.

(i) What would happen when the trigger is fired?

(ii) Discuss how this can affect normal database operations.

This is trigger for DEPT for each row to capture audit in audit_data. This tirgger will fire with insert, update, delete actions.

There are some logic to identify the actions like:

For insert - change_type = I,

for update - change_type = U

for Delete - change_type = D, in audit_data table.

It is also capturing user, date, and change_type in audit_data.

Addtionally, during insert, it will capture new DEPTNO, DNAME and LOC and during update it will capture old DEPTNO, DNAME and LOC.

Summary:

During insert operation, tigger will insert into

audit_data with change_type =I, changed_by := user, changed_time := sysdate, new DEPTNO, DNAME and LOC.

During Update operation, tigger will insert into

audit_data with change_type =U, changed_by := user, changed_time := sysdate, old DEPTNO, DNAME and LOC.

During Delete operation, tigger will insert into

audit_data with change_type =D, changed_by := user, changed_time := sysdate, old DEPTNO, DNAME and LOC.

Regards

Rijwan

1 Reply

Know the answer? Post it — somebody with the same question will find it here.