Oracle 18c

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

create table pl_db(COUNTRY,  NAME,  WMWHSE_ID) as (
select   'US',     'CRD2',     1  from dual union all
select   'GR',     'WAZ',      2  from dual union all
select   'CN',     'KOL',      3  from dual union all
select   'FR',     'DEL',      4  from dual )
4 rows affected

select country, name, wmwhse_id, trunc(sysdate) - level + 1 dt
  from pl_db 
  connect by level <= 7 and prior wmwhse_id = wmwhse_id and prior sys_guid() is not null 
  order by dt desc, wmwhse_id


COUNTRY
NAME
WMWHSE_ID
DT


US
CRD2
1
25-APR-24

GR
WAZ
2
25-APR-24

CN
KOL
3
25-APR-24

FR
DEL
4
25-APR-24

US
CRD2
1
24-APR-24

GR
WAZ
2
24-APR-24

CN
KOL
3
24-APR-24

FR
DEL
4
24-APR-24

US
CRD2
1
23-APR-24

GR
WAZ
2
23-APR-24

CN
KOL
3
23-APR-24

FR
DEL
4
23-APR-24

US
CRD2
1
22-APR-24

GR
WAZ
2
22-APR-24

CN
KOL
3
22-APR-24

FR
DEL
4
22-APR-24

US
CRD2
1
21-APR-24

GR
WAZ
2
21-APR-24

CN
KOL
3
21-APR-24

FR
DEL
4
21-APR-24

US
CRD2
1
20-APR-24

GR
WAZ
2
20-APR-24

CN
KOL
3
20-APR-24

FR
DEL
4
20-APR-24

US
CRD2
1
19-APR-24

GR
WAZ
2
19-APR-24

CN
KOL
3
19-APR-24

FR
DEL
4
19-APR-24


with r(country, name, wmwhse_id, dt, lvl) as (
  select country, name, wmwhse_id, trunc(sysdate), 1 from pl_db union all
  select country, name, wmwhse_id, trunc(sysdate) - lvl, lvl + 1 from r where lvl < 7)
select country, name, wmwhse_id, dt from r;


COUNTRY
NAME
WMWHSE_ID
DT


US
CRD2
1
25-APR-24

GR
WAZ
2
25-APR-24

CN
KOL
3
25-APR-24

FR
DEL
4
25-APR-24

US
CRD2
1
24-APR-24

GR
WAZ
2
24-APR-24

CN
KOL
3
24-APR-24

FR
DEL
4
24-APR-24

US
CRD2
1
23-APR-24

GR
WAZ
2
23-APR-24

CN
KOL
3
23-APR-24

FR
DEL
4
23-APR-24

US
CRD2
1
22-APR-24

GR
WAZ
2
22-APR-24

CN
KOL
3
22-APR-24

FR
DEL
4
22-APR-24

US
CRD2
1
21-APR-24

GR
WAZ
2
21-APR-24

CN
KOL
3
21-APR-24

FR
DEL
4
21-APR-24

US
CRD2
1
20-APR-24

GR
WAZ
2
20-APR-24

CN
KOL
3
20-APR-24

FR
DEL
4
20-APR-24

US
CRD2
1
19-APR-24

GR
WAZ
2
19-APR-24

CN
KOL
3
19-APR-24

FR
DEL
4
19-APR-24


select country, name, wmwhse_id, trunc(sysdate) - trim(column_value) + 1 dt
  from pl_db cross join xmltable('1 to 7')
  order by dt desc, wmwhse_id


COUNTRY
NAME
WMWHSE_ID
DT


US
CRD2
1
25-APR-24

GR
WAZ
2
25-APR-24

CN
KOL
3
25-APR-24

FR
DEL
4
25-APR-24

US
CRD2
1
24-APR-24

GR
WAZ
2
24-APR-24

CN
KOL
3
24-APR-24

FR
DEL
4
24-APR-24

US
CRD2
1
23-APR-24

GR
WAZ
2
23-APR-24

CN
KOL
3
23-APR-24

FR
DEL
4
23-APR-24

US
CRD2
1
22-APR-24

GR
WAZ
2
22-APR-24

CN
KOL
3
22-APR-24

FR
DEL
4
22-APR-24

US
CRD2
1
21-APR-24

GR
WAZ
2
21-APR-24

CN
KOL
3
21-APR-24

FR
DEL
4
21-APR-24

US
CRD2
1
20-APR-24

GR
WAZ
2
20-APR-24

CN
KOL
3
20-APR-24

FR
DEL
4
20-APR-24

US
CRD2
1
19-APR-24

GR
WAZ
2
19-APR-24

CN
KOL
3
19-APR-24

FR
DEL
4
19-APR-24


select power(124, 7) from dual


POWER(124,7)


450766669594624

COUNTRY	NAME	WMWHSE_ID	DT
US	CRD2	1	25-APR-24
GR	WAZ	2	25-APR-24
CN	KOL	3	25-APR-24
FR	DEL	4	25-APR-24
US	CRD2	1	24-APR-24
GR	WAZ	2	24-APR-24
CN	KOL	3	24-APR-24
FR	DEL	4	24-APR-24
US	CRD2	1	23-APR-24
GR	WAZ	2	23-APR-24
CN	KOL	3	23-APR-24
FR	DEL	4	23-APR-24
US	CRD2	1	22-APR-24
GR	WAZ	2	22-APR-24
CN	KOL	3	22-APR-24
FR	DEL	4	22-APR-24
US	CRD2	1	21-APR-24
GR	WAZ	2	21-APR-24
CN	KOL	3	21-APR-24
FR	DEL	4	21-APR-24
US	CRD2	1	20-APR-24
GR	WAZ	2	20-APR-24
CN	KOL	3	20-APR-24
FR	DEL	4	20-APR-24
US	CRD2	1	19-APR-24
GR	WAZ	2	19-APR-24
CN	KOL	3	19-APR-24
FR	DEL	4	19-APR-24