select * from yourtable where to_char(yourtime,'hh24:mi')>='1000' and to_char(yourtime,'hh24:mi')<='1200';
错了应该是:例如:select 'alter system kill session'||' '''||sid||','||serial#||''''||';' from v$session where to_char(logon_time,'hh24mi') >='0810' and to_char(logon_time,'hh24mi')<='0920' and status='INACTIVE';
针对你的select * from yourtable where to_char(yourtime,'hh24mi')>='1000' and to_char(yourtime,'hh24mi')<='1200';改成你的表名和字段名即可
where to_char(logon_time,'hh24mi') >='0810' and to_char(logon_time,'hh24mi')<='0920' and status='INACTIVE';