Creating DML Triggers:Part 2
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.
Watch Sheila use the Object Browser to create a trigger that does not allow DML during nonbusiness hours. Also, watch Sheila use the SQL Workshop tool to see the results from the trigger failing.
 |
