摘要:
1:模拟一张表来查询日期范围的连续性create table myrecords( id number, start_date number, --开始时间 end_date number --结束时间);insert into myrecords values (1,20100101,20101231);insert into myrecords values (1,20100101,20110231);insert into myrecords values (1,20100202,20100303);insert into myrecords values (2,20100101,20. 阅读全文