regexp_like(字段,'^[0-9]+$') and not regexp_like(字段,'^01')
with a as (select'02999' rec from dual union select '01888' from dual union select '02dfd56dd' from dual ) select regexp_replace(rec, '\D', '') from a where regexp_like(substr(rec, 1, 2), '[^01]');
regexp_like(字段,'^[0-9]+$') and not regexp_like(字段,'^01')
(select'02999' rec from dual
union
select '01888' from dual
union
select '02dfd56dd' from dual
)
select regexp_replace(rec, '\D', '') from a
where regexp_like(substr(rec, 1, 2), '[^01]');