Show Me
 

Creating a DML Trigger

Previous previous|next Next Page

Sheila begins working on creating a trigger to restrict all data manipulation events on the EMPLOYEES table to certain business hours, Monday through Friday. She needs to include the special conditional predicates INSERTING, UPDATING, and DELETING within the trigger body.

Help Sheila create a trigger that does not allow DML during non-business hours. Watch the results when the trigger fires and does not allow the action.

Launch Demonstration

Show Me and Try It