By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with mynumbers as (
select 1.00001 num from dual
union all select 1.00012 from dual
union all select 1.00123 from dual
union all select 1.01234 from dual
union all select 1.12345 from dual
union all select 1.12340 from dual
union all select 1.12300 from dual
union all select 1.12000 from dual
union all select 1.10000 from dual
),
myscale as (select 4 sca from dual)
select *
from mynumbers n
inner join myscale s
on trunc(n.num * power(10, s.sca)) <> n.num * power(10, s.sca)
| NUM | SCA |
|---|---|
| 1.00001 | 4 |
| 1.00012 | 4 |
| 1.00123 | 4 |
| 1.01234 | 4 |
| 1.12345 | 4 |