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)
;