Hi I have a requirement in my application is to get the data as follows
please find the eg. data and table
CREATE TABLE "TEST2"
( "ID_NBR" NUMBER,
"ORDER_ID" NUMBER,
"START_DATE" DATE,
"END_DATE" DATE
) ;
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (1,101,to_date('09-OCT-25','DD-MON-RR'),to_date('18-OCT-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (2,101,to_date('02-OCT-25','DD-MON-RR'),to_date('09-OCT-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (3,101,to_date('15-SEP-25','DD-MON-RR'),to_date('02-OCT-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (4,100,to_date('21-AUG-25','DD-MON-RR'),to_date('29-AUG-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (5,100,to_date('15-AUG-25','DD-MON-RR'),to_date('21-AUG-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (6,100,to_date('15-AUG-25','DD-MON-RR'),to_date('21-AUG-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (7,100,to_date('14-AUG-25','DD-MON-RR'),to_date('15-AUG-25','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (8,100,to_date('31-OCT-24','DD-MON-RR'),to_date('05-NOV-24','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (9,100,to_date('07-JUN-24','DD-MON-RR'),to_date('21-JUN-24','DD-MON-RR'));
Insert into TEST2 (ID_NBR,ORDER_ID,START_DATE,END_DATE) values (10,100,to_date('04-JUN-24','DD-MON-RR'),to_date('07-JUN-24','DD-MON-RR'));
output should be with
order_id, start_date and End_date
without gaps
for eg as shown in the picture
100 04th june 2024 last max end date without gaps is 21st june 2024
100 31st oct 2024 05th nov 2024 as there are gaps between the above record and the next
same for the remaining
how to get this please
thanks.
