Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table it0610 (
 df_date date
);

insert into it0610 values (to_date('2022-06-03', 'yyyy-mm-dd'));
1 rows affected

insert into it0610 values (to_date('2022-06-04', 'yyyy-mm-dd'));
1 rows affected

insert into it0610 values (to_date('2022-06-05', 'yyyy-mm-dd'));
1 rows affected

insert into it0610 values (to_date('2022-06-10', 'yyyy-mm-dd'));
1 rows affected

insert into it0610 values (to_date('2022-06-11', 'yyyy-mm-dd'));
1 rows affected

ALTER SESSION  SET NLS_DATE_FORMAT = 'YYYY-MM-DD';
select *
  from it0610;


DF_DATE


2022-06-03

2022-06-04

2022-06-05

2022-06-10

2022-06-11


with t1(n) as (
select 1
  from dual
 union all
select n + 1
  from t1
 where n < 10
), t2 (be_date) as (
SELECT to_date('2022-06-06', 'yyyy-mm-dd') - n 
  FROM t1
), t3 (be_date) as (
select be_date
  from t2
 minus
select df_date
  from it0610
)
select max(be_date)
  from t3;
 


MAX(BE_DATE)


2022-06-02


with t1(n) as (
select 1
  from dual
 union all
select n + 1
  from t1
 where n < 10
), t2 (be_date) as (
SELECT to_date('2022-06-09', 'yyyy-mm-dd') - n 
  FROM t1
), t3 (be_date) as (
select be_date
  from t2
 minus
select df_date
  from it0610
)
select max(be_date)
  from t3;


MAX(BE_DATE)


2022-06-08