select case when to_number(to_char(sysdate,hh24)) between 6 and 11 then '上午' when to_number(to_char(sysdate,hh24)) between 11 and 17 then '下午' when to_number(to_char(sysdate,hh24)) between 17 and 21 then '晚上' end from dual;
select case when f1>f2 then '内容1' when f1<f2 then '内容2' end from aaa;
when to_number(to_char(sysdate,hh24)) between 6 and 11 then '上午'
when to_number(to_char(sysdate,hh24)) between 11 and 17 then '下午'
when to_number(to_char(sysdate,hh24)) between 17 and 21 then '晚上'
end
from dual;
when f1>f2 then '内容1'
when f1<f2 then '内容2'
end
from aaa;