Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table T as
  select
    'A.H.4.1.2.0000.pas A.H.4.1.2.0000.poc A.H.410000.poc A.H.420000.poc A.H.4.1.2.0000.Total A.H.4 B.I.5.2.3.1111.poc' value
  from dual;
1 rows affected

select
  listagg(upd_val, chr(13)) within group (order by rn) upd_val,
  value
from (
  select
    level rn,
    value,
    regexp_substr(value, '\S+', 1, level) upd_val
  from T
  connect by regexp_substr(value, '\S+', 1, level) is not null
)
where not regexp_like(upd_val, '\.p(as|oc)$')
group by value;


UPD_VAL
VALUE


A.H.4.1.2.0000.Total
A.H.4
A.H.4.1.2.0000.pas A.H.4.1.2.0000.poc A.H.410000.poc A.H.420000.poc A.H.4.1.2.0000.Total A.H.4 B.I.5.2.3.1111.poc