1、创建测试表,
create table test_date(id number, times date);
2、插入测试数据
insert into test_date select level, sysdate-level/24/60 t from dual connect by level <= 100;
commit;
3、查询表中数据,select t.* from test_date t;
4、编写sql,获取加5分钟大于等于当前系统时间的记录; select t.* from test_date t where times+5/24/60>=sysdate;