Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (date_column) AS
SELECT /*SYSDATE*/ DATE '2022-11-12' - (LEVEL - 1)
FROM   DUAL
CONNECT BY LEVEL <= 20;
20 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD (DY)';
SELECT *
FROM   table_name
WHERE  date_column >= TRUNC(/*SYSDATE*/ DATE '2022-11-12' - 5, 'iw') - 2
AND    date_column <  TRUNC(/*SYSDATE*/ DATE '2022-11-12' - 5, 'iw') + 5

DATE_COLUMN

2022-11-11 (FRI)

2022-11-10 (THU)

2022-11-09 (WED)

2022-11-08 (TUE)

2022-11-07 (MON)

2022-11-06 (SUN)

2022-11-05 (SAT)

SELECT *
FROM   table_name
WHERE  date_column >= TRUNC(/*yesterday*/ DATE '2022-11-11' - 5, 'iw') - 2
AND    date_column <  TRUNC(/*yesterday*/ DATE '2022-11-11' - 5, 'iw') + 5

DATE_COLUMN

2022-11-04 (FRI)

2022-11-03 (THU)

2022-11-02 (WED)

2022-11-01 (TUE)

2022-10-31 (MON)

2022-10-30 (SUN)

2022-10-29 (SAT)

SELECT *
FROM   table_name
WHERE  date_column >= TRUNC(/*SYSDATE*/ DATE '2022-11-12', 'iw') - 2
AND    date_column <  TRUNC(/*SYSDATE*/ DATE '2022-11-12', 'iw') + 5

DATE_COLUMN

2022-11-11 (FRI)

2022-11-10 (THU)

2022-11-09 (WED)

2022-11-08 (TUE)

2022-11-07 (MON)

2022-11-06 (SUN)

2022-11-05 (SAT)