1、创建测试表,
create table test_date(id varchar2(20),v_date date);
2、插入测试数据;
insert into test_date select level, trunc(sysdate)+level v_date from dual connect by level<=5
commit;
3、查询表中全量数据;select t.*, rowid from test_date t;
4、编写语句,查询时间等于当前时间后两天的记录;
select t.*, rowid from test_date t where v_date = trunc(sysdate)+2;