CREATE OR REPLACE TRIGGER emp_trigger
BEFORE INSERT OR DELETE OR UPDATE ON employee1
DECLARE
v_day varchar(30):=TO_CHAR(sysdate,’dy’);
BEGIN
IF v_day IN ('sat','sun')
THEN
RAISE_APPLICATION_ERROR (-20501,'You may Access
EMPLOYEES table only during business hours.');
END IF;
END;
/

