Hi There,
I am unable to figure why I am getting the below error:
[Error Code: 905, SQL State: 42000] ORA-00905: missing keyword
Below is the SQL query:
select case_id from case_routing
where to_state_id in (100012, 100015)
and case when to_char(sysdate, 'fmDay') = 'Monday'
then
trunc(route_date) = trunc(sysdate-3)
else
trunc(route_date) = trunc(sysdate-1)
end
Any inputs or suggestions will be greatly appreciated.
Thanks,
K