create or replace trigger foremp
before insert on emp
declare
day char(10);
begin
if (to_char(sysdate,day) in ('sunday')) then
raise_application_error(-20300,'not allowed on sunday');
end if;
end;
/ I created this trigger to avoid insert on emp table on sunday. But it takes value on sunday also. What is the mistake tell please.

thank u.

SQL> select 'x'||to_char(sysdate,'DAY')||'x' from dual;

'X'||TO_CHA
-----------
xSUNDAY   x