NO CHANGES CAN BE DONE ON A PARTICULAR TABLE ON SUNDAY AND SATURDAY

Create or replace trigger change before on emp

for each row when (to_char(sysdate,’dy’) in (’SAT’,'SUN’)) 

begin

raise_application_error(-200001, ‘u cannot enter data in saturnday and sunday’);

end;