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 | 13-FEB-25 |
| GR | WAZ | 2 | 13-FEB-25 |
| CN | KOL | 3 | 13-FEB-25 |
| FR | DEL | 4 | 13-FEB-25 |
| US | CRD2 | 1 | 12-FEB-25 |
| GR | WAZ | 2 | 12-FEB-25 |
| CN | KOL | 3 | 12-FEB-25 |
| FR | DEL | 4 | 12-FEB-25 |
| US | CRD2 | 1 | 11-FEB-25 |
| GR | WAZ | 2 | 11-FEB-25 |
| CN | KOL | 3 | 11-FEB-25 |
| FR | DEL | 4 | 11-FEB-25 |
| US | CRD2 | 1 | 10-FEB-25 |
| GR | WAZ | 2 | 10-FEB-25 |
| CN | KOL | 3 | 10-FEB-25 |
| FR | DEL | 4 | 10-FEB-25 |
| US | CRD2 | 1 | 09-FEB-25 |
| GR | WAZ | 2 | 09-FEB-25 |
| CN | KOL | 3 | 09-FEB-25 |
| FR | DEL | 4 | 09-FEB-25 |
| US | CRD2 | 1 | 08-FEB-25 |
| GR | WAZ | 2 | 08-FEB-25 |
| CN | KOL | 3 | 08-FEB-25 |
| FR | DEL | 4 | 08-FEB-25 |
| US | CRD2 | 1 | 07-FEB-25 |
| GR | WAZ | 2 | 07-FEB-25 |
| CN | KOL | 3 | 07-FEB-25 |
| FR | DEL | 4 | 07-FEB-25 |
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 | 13-FEB-25 |
| GR | WAZ | 2 | 13-FEB-25 |
| CN | KOL | 3 | 13-FEB-25 |
| FR | DEL | 4 | 13-FEB-25 |
| US | CRD2 | 1 | 12-FEB-25 |
| GR | WAZ | 2 | 12-FEB-25 |
| CN | KOL | 3 | 12-FEB-25 |
| FR | DEL | 4 | 12-FEB-25 |
| US | CRD2 | 1 | 11-FEB-25 |
| GR | WAZ | 2 | 11-FEB-25 |
| CN | KOL | 3 | 11-FEB-25 |
| FR | DEL | 4 | 11-FEB-25 |
| US | CRD2 | 1 | 10-FEB-25 |
| GR | WAZ | 2 | 10-FEB-25 |
| CN | KOL | 3 | 10-FEB-25 |
| FR | DEL | 4 | 10-FEB-25 |
| US | CRD2 | 1 | 09-FEB-25 |
| GR | WAZ | 2 | 09-FEB-25 |
| CN | KOL | 3 | 09-FEB-25 |
| FR | DEL | 4 | 09-FEB-25 |
| US | CRD2 | 1 | 08-FEB-25 |
| GR | WAZ | 2 | 08-FEB-25 |
| CN | KOL | 3 | 08-FEB-25 |
| FR | DEL | 4 | 08-FEB-25 |
| US | CRD2 | 1 | 07-FEB-25 |
| GR | WAZ | 2 | 07-FEB-25 |
| CN | KOL | 3 | 07-FEB-25 |
| FR | DEL | 4 | 07-FEB-25 |
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 | 13-FEB-25 |
| GR | WAZ | 2 | 13-FEB-25 |
| CN | KOL | 3 | 13-FEB-25 |
| FR | DEL | 4 | 13-FEB-25 |
| US | CRD2 | 1 | 12-FEB-25 |
| GR | WAZ | 2 | 12-FEB-25 |
| CN | KOL | 3 | 12-FEB-25 |
| FR | DEL | 4 | 12-FEB-25 |
| US | CRD2 | 1 | 11-FEB-25 |
| GR | WAZ | 2 | 11-FEB-25 |
| CN | KOL | 3 | 11-FEB-25 |
| FR | DEL | 4 | 11-FEB-25 |
| US | CRD2 | 1 | 10-FEB-25 |
| GR | WAZ | 2 | 10-FEB-25 |
| CN | KOL | 3 | 10-FEB-25 |
| FR | DEL | 4 | 10-FEB-25 |
| US | CRD2 | 1 | 09-FEB-25 |
| GR | WAZ | 2 | 09-FEB-25 |
| CN | KOL | 3 | 09-FEB-25 |
| FR | DEL | 4 | 09-FEB-25 |
| US | CRD2 | 1 | 08-FEB-25 |
| GR | WAZ | 2 | 08-FEB-25 |
| CN | KOL | 3 | 08-FEB-25 |
| FR | DEL | 4 | 08-FEB-25 |
| US | CRD2 | 1 | 07-FEB-25 |
| GR | WAZ | 2 | 07-FEB-25 |
| CN | KOL | 3 | 07-FEB-25 |
| FR | DEL | 4 | 07-FEB-25 |
select power(124, 7) from dual
| POWER(124,7) |
|---|
| 450766669594624 |