Write a trigger that is fired before the DML statement’s execution on the EMPLOYEE table. The trigger checks the day based on SYSDATE. If the day is Sunday, the trigger does not allow the DML statement’s execution and raises an exception. Write the appropriate message in the exception-handling section.

Question

What will be an ideal response?

Answer 1

```
SQL> CREATE OR REPLACE TRIGGER sunday_trigger
2 BEFORE INSERT OR DELETE OR UPDATE ON EMPLOYEE
3 FOR EACH ROW
4 DECLARE
5 sunday_ex EXCEPTION;
6 BEGIN
7 IF TO_CHAR(SYSDATE, 'DAY') = 'SUNDAY' THEN
8 RAISE sunday_ex;
9 END IF;
10 EXCEPTION
11 WHEN sunday_ex THEN
12 DBMS_OUTPUT.PUT_LINE('No DML allowed on Sunday');
13 END;
14 /

Trigger created.
```