Question: Create a DML database trigger ( CHK _ DML ) on emp table, which permits DML operation only during weekdays ( MON - FRI )

Create a DML database trigger (CHK_DML) on emp table, which permits DML operation only during weekdays (MON - FRI) and between 7:00 am to 3:00 pm. Include the necessary exception handling and appropriate message.
Run the INSERT, UPDATE and DELETE statement to test the trigger.
-- Use emp table , and make appropriate assumptions if you need to.

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!