Question: SQL Create the following table: greate table audit emp aation varchar? (20), date asti date default sysdate) Create the following trigger: CREATE OR REPLACE TRIGGER

 SQL Create the following table: greate table audit emp aation varchar?

SQL

Create the following table: greate table audit emp aation varchar? (20), date asti date default sysdate) Create the following trigger: CREATE OR REPLACE TRIGGER audit e AFTER DELETE ON employees For EACH ROW BEGIN IE DELETING THEN INSERT INTO audis emp VALUES (USER 'DELETE' SYSDATE) END IF END: Modify the trigger and test: Perform the following: . Now modify the trigger to include an audit trail in case the employees table is changed with an UPDATE or INSERT, (Hint: you may want to use the conditional predicates INSERTING or UPDATING). Once you have made your changes test by (1) adding a new employee, (2) then make a change to the employee you added and (3) finally deleting the employee you added. . . Use a SELECT statement to display the contents of the audit emp table

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!