WITH t AS
(
SELECT '22:00:00' s_time, '09:00:00' e_time FROM dual
UNION ALL SELECT '13:00:00', '17:00:00' FROM dual
UNION ALL SELECT '20:00:00', '05:00:00' FROM dual
)
SELECT s_time, e_time
  FROM t
 WHERE ( s_time <= e_time AND
         TO_CHAR(sysdate, 'hh24:mi:ss') BETWEEN s_time AND e_time
       )
    OR ( s_time > e_time AND
         ( TO_CHAR(sysdate, 'hh24:mi:ss') BETWEEN s_time AND '23:59:59'
           OR
           TO_CHAR(sysdate, 'hh24:mi:ss') BETWEEN '00:00:00' AND e_time
         )
       )
;