select a,b
  from t 
  match_recognize(
  partition by b
  order by a
  measures match_number() as mn
  all rows per match
  pattern(m1+ m2+ m3+)
  define m1 as a=11
       , m2 as a=22
       , m3 as a=37
  )
 where a in (22, 37, 11)
;

select a,b 
  from (
    select xmlelement("r", xmlagg(xmlelement("z", xmlforest(a, b)))as "a") x
     from t
    where a in (22, 37, 11)
    group by b
    having 3 = count (distinct a)
    ), xmltable('/r/z' passing x columns a,b)
;

select a,b
  from (select * from t where a in (22, 37, 11))
  match_recognize(
  partition by b
  order by a
  measures match_number() as mn
  all rows per match
  pattern(m1+ m2+ m3+)
  define m1 as a=11
       , m2 as a=22
       , m3 as a=37
  )
;

select a,b
  from t
  where a in (22,37,11)
  model return updated rows
    partition by (b)
    dimension by (count(distinct a) over(partition by b) c, rownum r)
    measures (a as a)
    rules(a[3,any] = a[cv(),cv()])
;

pattern({-m0-}* m1+ {-m0-}* m2+ {-m0-}* m3+)

pattern({-m0-}* m1+ {-m0-}* m2+ {-m0-}* m3+)

select a,b
from (
select t.*
     , ','||listagg(a,',') within group(order by a) over(partition by b)||',' f
  from t
 where a in (22, 37, 11)
) x
where 3 = sign(instr(f,',22,'))+sign(instr(f,',11,'))+sign(instr(f,',37,')) 
;

with p as (select *
          from t
         pivot ( count(a) for a in (22,37,11))
         where "22">0 and "37">0 and "11">0
)
, u as ( select * from p
        unpivot ( mx_count for a in ("22", "37", "11"))
)
select a,b 
  from u
     , lateral(select null from dual connect by level <=mx_count)
;

with p as (select *
          from t
         pivot ( count(a) for a in (22,37,11))
         where "22">0 and "37">0 and "11">0
)
select a,b
  from p
     , lateral ( select 22 a from dual connect by level <= p."22"
       union all select 11  from dual connect by level <= p."11"
       union all select 37  from dual connect by level <= p."37"
     )

with "Интригал"(b3) as(
select b  
  from t
 where a in (11,22,37)
 group by b
having count(distinct a) = 3
)
select a,b from "Интригал", t where b3=b and a in (11,22,37)
;

with k(b, a, c, cunq) as(
select b, a, count(a), count(distinct a)
  from t
 where a in (11,22,37)
 group by grouping sets(b, (b,a))
) 
, "Интригал"(a, b, c) as (
select a, b, 1e38
  from k where a is null and cunq = 3
union all 
select k.a, k.b, case i.c when 1e38 then k.c else i.c-1 end
  from "Интригал" i, k
 where i.b = k.b 
   and nvl(i.a, k.a) = k.a 
   and i.c > 1
)
select a,b 
  from "Интригал" 
 where a is not null
;

with "Интригал"(b, ta) as(
select b, cast(collect(a) as SYS.ku$_ObjNumSet) t
  from t
 group by b
having 3 = cardinality(cast(collect(a) as SYS.ku$_ObjNumSet) multiset intersect distinct SYS.ku$_ObjNumSet(11,22,37))
)
select column_value a, b 
  from "Интригал", table(ta)
;

with "Интригал"(b, ta) as(
select b, cast(collect(a) as SYS.ku$_ObjNumSet) t
  from t
 where a in (11,22,37)
 group by b
having 3 = cardinality(cast(collect(a) as SYS.ku$_ObjNumSet) multiset intersect distinct SYS.ku$_ObjNumSet(11,22,37))
)
select column_value a, b 
  from "Интригал", table(ta)
;

with "Интригал"(b, ta) as(
select b, cast(collect(a) as SYS.ku$_ObjNumSet)
  from t
 where a in (11,22,37)
 group by b
having SYS.ku$_ObjNumSet(11,22,37) multiset except cast(collect(a) as SYS.ku$_ObjNumSet)  = SYS.ku$_ObjNumSet()
)
select column_value a, b
  from "Интригал", table(ta)
;