SQL> CREATE TABLE binary_test (
2 bin_float BINARY_FLOAT,
3 bin_double BINARY_DOUBLE
4 );
Table created.
SQL>
SQL> INSERT INTO binary_test (
2 bin_float, bin_double
3 ) VALUES (
4 39.5f, 15.7d
5 );
1 row created.
SQL>
SQL> INSERT INTO binary_test (
2 bin_float, bin_double
3 ) VALUES (
4 BINARY_FLOAT_INFINITY, BINARY_DOUBLE_INFINITY
5 );
1 row created.
SQL>
SQL> drop table binary_test;
Table dropped.