Question: I am using the oracel sql developer so plz answer through the oracel sql developer 6-(10%) Take the 2 triggers you have previously created and

I am using the oracel sql developer so plz answer through the oracel sql developer
6-(10%) Take the 2 triggers you have previously created and combine theminto a single trigger called staff_trig which continues to provide all the

6-(10%) Take the 2 triggers you have previously created and combine them into a single trigger called staff_trig which continues to provide all the functionality of the previous triggers - and - also handles a DELETE by recording (INSERT) a record into the STAFFAUDTBL when a DELETE occurs. Here is the new STAFFAUDTBL schema and how to handle I/U/D: Columns: - ID (ID of the record being affected) ACTION ("1" or "U" or "D" based on what action is happening) INCJOB (The value of a non-valid JOB in the case of an INSERT or UPDATE, otherwise NULL if JOB value is fine - see valid values in Q3) OLDCOMM (The value of old commission if there is ANY change to COMM from an UPDATE, otherwise NULL) - NEWCOMM (The value of new commission if there is ANY change to COMM from an UPDATE, otherwise NULL) Drop the existing STAFFAUDTBL. Create a new STAFFAUDTBL. Make sure you DISABLE your two existing triggers so both don't fire at the same time. Test your new trigger.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!