select to_char(last_analyzed, 'YYYYMMDDHH24MISS')
from all_tables
where
last_analyzed between
to_date('01.10.2005', 'DD.MM.YYYY') and to_date('23.03.2006', 'DD.MM.YYYY')
and
to_number(to_char(trunc(last_analyzed, 'HH24'),'HH24'), '99')
between 8 and 19
order by last_analyzed;

smeni si tam s twoite neshta