--
-- Твои тестовые данные:
with
  t1 as 
    (
      select 0 b, 100 e, 'A1' f from dual union all
      select 100 b, 200 e, 'A2' f from dual union all
      select 200 b, 300 e, 'A3' f from dual union all
      select 300 b, 400 e, 'A4' f from dual
    )
, t2 as
    (
      select 0 b,250 e,'B1' f from dual union all
      select 250 b, 400 e,'B2' from dual
    )
--
-- Идеи Elic-a в коде:
select i.b, i.e, t1.f as f1, t2.f as f2
 from (
        select p as b, lead(p) over(order by p) as e
          from (
                 select b as p from t1 union
                 select b as p from t2 union
                 select e as p from t1 union
                 select e as p from t2
               ) points
      ) i
  join t1
    on t1.e > i.b
   and t1.b < i.e
  join t2
    on t2.e > i.b
   and t2.b < i.e
 order by i.b