目录
定位连续的值区间
想得到V5视图中(每一行的项目结束时间都等于后一行的项目开始时间的部分)
(即“连续”的部分)
create view V5 (PROJ_ID,PROJ_START,PROJ_END)
as
select 1, '01-JAN-2005', '02-JAN-2005' from t1 union all
select 2, '02-JAN-2005', '03-JAN-2005' from t1 union all
select 3, '03-JAN-2005', '04-JAN-2005' from t1 union all
select 4, '04-JAN-2005', '05-JAN-2005' from t1 union all
select 5, '06-JAN-2005', '07-JAN-2005' from t1 union all
select 6, '16-JAN-2005', '17-JAN-2005' from t1 union all
select 7, '17-JAN-2005', '18-JAN-2005' from t1 union all
select 8, '18-JAN-2005', '19-JAN-2005' from t1 union all
select 9, '19-JAN-2005', '20-JAN-2005' from t1 union all
select 10, '21-JAN-2005',