with t as ( select '1010 3576 1234 123' id from dual union all select '1010 3576 1234123' id from dual union all select '1010 35761234 123' id from dual union all select '1010 3576 1x34 123' id from dual union all select '1010 2576 1234 103' id from dual union all select '1010 35761234123' id from dual union all select '1010 3576 0234 123' id from dual ) select * from t where regexp_like(id,'1010 3576 [[:digit:]]{4} [[:digit:]]{3}');
with t as
(
select '1010 3576 1234 123' id from dual union all
select '1010 3576 1234123' id from dual union all
select '1010 35761234 123' id from dual union all
select '1010 3576 1x34 123' id from dual union all
select '1010 2576 1234 103' id from dual union all
select '1010 35761234123' id from dual union all
select '1010 3576 0234 123' id from dual
)
select * from t where regexp_like(id,'1010 3576 [[:digit:]]{4} [[:digit:]]{3}');