Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE binary_test (bin_float BINARY_FLOAT, bin_double BINARY_DOUBLE, NUM NUMBER);
INSERT INTO binary_test VALUES (4356267548.32345E+100, 4356267548.32345E+2+300, 4356267548.32345E+100);
1 rows affected

INSERT INTO binary_test VALUES (4356267548.32345E+100, 4356267548.32345E+298d, 4356267548.32345E+100);
1 rows affected

SELECT CASE WHEN bin_double>to_binary_double(num) THEN 'Greater'
            WHEN bin_double=to_binary_double(num) THEN 'Equal'
            WHEN bin_double<to_binary_double(num) THEN 'Lower'
            ELSE 'Unknown' END comparison,
            A.*
FROM binary_test A;


COMPARISON
BIN_FLOAT
BIN_DOUBLE
NUM


Lower
Inf
4.3562675513234497E+011
43562675483234500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Greater
Inf
4.3562675483234498E+307
43562675483234500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000


select 4356267548.32345E+2, 4356267548.32345E+2+300
from dual


4356267548.32345E+2
4356267548.32345E+2+300


435626754832.345
435626755132.345

COMPARISON	BIN_FLOAT	BIN_DOUBLE	NUM
Lower	Inf	4.3562675513234497E+011	43562675483234500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Greater	Inf	4.3562675483234498E+307	43562675483234500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000