By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release | Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0 |
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release | 0 |
select 1e-130;
| 1E-130 |
|---|
| .0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001 |
select 1e-131;
| 1E-131 |
|---|
| 0 |
select 1 from DUAL where 0.0 < 1e-130;
| 1 |
|---|
| 1 |
select 1 from DUAL where 0.0 < 1e-131;