根据【开始】【结束日期】查询数据库数据

select count(*)
  from sd_log sl
 where sl.create_date >= to_date('20160504 00:00:00', 'yyyymmdd hh24:mi:ss')

   and sl.create_date <= to_date('20160504 23:59:59', 'yyyymmdd hh24:mi:ss');

SELECT inst_id FROM inst_table start WITH inst_id='XXX' connect BY prior inst_id = inst_up ;