Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
0


create table mytable (car_id varchar2(100), created_at date, car_mileage int);
begin
  insert into mytable values ('d016e61c5326-f246894a', date '2023-05-22', 100000);
  insert into mytable values ('d016e61c5326-f246894a', date '2023-05-26', 105000);
  insert into mytable values ('d016e61c5326-f246894a', date '2023-05-27', 110000);
end;
/
1 rows affected

with cte (car_id, created_at, car_mileage, next_created_at) as
(
  select
    car_id, created_at, car_mileage,
    lead(created_at) over (partition by car_id order by created_at)
  from mytable
  union all
  select car_id, created_at + interval '1' day, car_mileage, next_created_at
  from cte
  where created_at + interval '1' day < next_created_at
)
select car_id, created_at, car_mileage
from cte
order by car_id, created_at;


CAR_ID
CREATED_AT
CAR_MILEAGE


d016e61c5326-f246894a
22-MAY-23
100000

d016e61c5326-f246894a
23-MAY-23
100000

d016e61c5326-f246894a
24-MAY-23
100000

d016e61c5326-f246894a
25-MAY-23
100000

d016e61c5326-f246894a
26-MAY-23
105000

d016e61c5326-f246894a
27-MAY-23
110000

CAR_ID	CREATED_AT	CAR_MILEAGE
d016e61c5326-f246894a	22-MAY-23	100000
d016e61c5326-f246894a	23-MAY-23	100000
d016e61c5326-f246894a	24-MAY-23	100000
d016e61c5326-f246894a	25-MAY-23	100000
d016e61c5326-f246894a	26-MAY-23	105000
d016e61c5326-f246894a	27-MAY-23	110000