--
-- Тестовые данные:
with
--
-- Таблица А:
  A as 
    (
      select 1 as point_name, 'paramA' as param_name from dual union all
      select 1 as point_name, 'paramB' as param_name from dual union all
      select 1 as point_name, 'paramE' as param_name from dual union all
      select 2 as point_name, 'paramA' as param_name from dual union all
      select 2 as point_name, 'paramB' as param_name from dual union all
      select 2 as point_name, 'paramC' as param_name from dual union all
      select 2 as point_name, 'paramD' as param_name from dual union all
      select 2 as point_name, 'paramE' as param_name from dual union all
      select 2 as point_name, 'paramF' as param_name from dual
    )
--
-- Таблица В:
, B as
  (
      select 'paramA' as param_name from dual union all
      select 'paramB' as param_name from dual union all
      select 'paramC' as param_name from dual union all
      select 'paramD' as param_name from dual union all
      select 'paramE' as param_name from dual union all
      select 'paramF' as param_name from dual union all
      select 'paramG' as param_name from dual
   )
--
-- Основной запрос:
select *
  from b 
  left join a partition by (a.point_name)
    on a.param_name = b.param_name
 where A.param_name is null
 order by a.point_name, b.param_name