By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mig_test (store int, VARCHAR2_1 varchar (20))
insert into mig_test values (30816 , '26.399883');
1 rows affected
insert into mig_test values (30074, '29.58.20.9');
1 rows affected
insert into mig_test values (30088, '90.02');
1 rows affected
select *
from (SELECT REGEXP_COUNT(sce.VARCHAR2_1, '[.]') cnt
, sce.store
, VARCHAR2_1
FROM mig_test sce)
where cnt = 1
and CAST(VARCHAR2_1 as number) > 90;
| CNT | STORE | VARCHAR2_1 |
|---|---|---|
| 1 | 30088 | 90.02 |
SELECT REGEXP_COUNT(sce.VARCHAR2_1, '[.]') cnt
, sce.store
, VARCHAR2_1
FROM mig_test sce
| CNT | STORE | VARCHAR2_1 |
|---|---|---|
| 1 | 30816 | 26.399883 |
| 3 | 30074 | 29.58.20.9 |
| 1 | 30088 | 90.02 |