with b as (
select  '236012, ОБЛАСТЬ КАЛИНИНГРАДСКАЯ, Г. КАЛИНИНГРАД, УЛ КОМСОМОЛЬСКАЯ, Д12 К. А, ПОМЕЩ 25' as full_address from dual union all
select  '236012, ОБЛАСТЬ КАЛИНИНГРАДСКАЯ, Г. КАЛИНИНГРАД, УЛ КОМСОМОЛЬСКАЯ, Д24 К. А, ПОМЕЩ 25' as full_address from dual union all
select  '236012, ОБЛАСТЬ КАЛИНИНГРАДСКАЯ, Г. КАЛИНИНГРАД, УЛ КОМСОМОЛЬСКАЯ, Д35 К. А, ПОМЕЩ 25' as full_address from dual 
),
a as (
select 12 as number_house from dual union all
select 24 as number_house from dual union all
select 112 as number_house from dual
)
select a.*,b.*
from a , b 
where (REGEXP_like(b.full_address,'\D'||a.number_house||'\D'))