By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mig_test (store number, varchar2_1 varchar2(20));
insert into mig_test
select 1, '26.399883' from dual union all
select 2, '29.58.20.9' from dual union all
select 3, '100.449' from dual;
3 rows affected
with valid_values as
(select store,
cast (varchar2_1 as number) varc --> cast to number
from mig_test
where regexp_count(varchar2_1, '\.') <= 1 --> remove invalid rows
)
select *
From valid_values
where varc > 90;
| STORE | VARC |
|---|---|
| 3 | 100.449 |