CAST_FROM_BINARY_FLOAT

The CAST_FROM_BINARY_FLOAT function returns a BINARY_FLOAT value in the binary RAW representation.

Syntax

UTL_RAW.CAST_FROM_BINARY_FLOAT(
   n          IN BINARY_FLOAT,
   endianess  IN PLS_INTEGER DEFAULT 1)
RETURN RAW;

Parameters

Return values

The binary representation (RAW) of a BINARY_FLOAT value is returned.

Considerations

• The following list shows the mapping between a 4-byte BINARY_FLOAT value and the IEEE 754 single-precision format:

  byte 0: bit 31–bit 24
  byte 1: bit 23–bit 16
  byte 2: bit 15–bit 8
  byte 3: bit 7–bit 0
  

• The endianess parameter describes how BINARY_FLOAT bytes are mapped to RAW bytes, as shown in the following matrix. rb0–rb3 are the RAW bytes, and fb0–fb3 are the BINARY_FLOAT bytes. | endianess | rb0 | rb1 | rb2 | rb3 | | --- | --- | --- | --- | --- | | big_endian | fb0 | fb1 | fb2 | fb3 | | little_endian | fb3 | fb2 | fb1 | fb0 |

• For machine-endian, the 4 bytes of the BINARY_FLOAT parameter are copied directly into the return RAW value. Passing big_endian on a big-endian machine has the same effect as passing little_endian on a little-endian machine.

Examples

obclient> SELECT UTL_RAW.CAST_FROM_BINARY_FLOAT(0) FROM DUAL;
+-----------------------------------+
| UTL_RAW.CAST_FROM_BINARY_FLOAT(0) |
+-----------------------------------+
| 00000000                          |
+-----------------------------------+
1 row in set

obclient> SELECT UTL_RAW.CAST_FROM_BINARY_FLOAT(1.234) FROM DUAL;
+---------------------------------------+
| UTL_RAW.CAST_FROM_BINARY_FLOAT(1.234) |
+---------------------------------------+
| 3F9DF3B6                              |
+---------------------------------------+
1 row in set

obclient> SELECT UTL_RAW.CAST_FROM_BINARY_FLOAT(-1.234) FROM DUAL;
+----------------------------------------+
| UTL_RAW.CAST_FROM_BINARY_FLOAT(-1.234) |
+----------------------------------------+
| BF9DF3B6                               |
+----------------------------------------+
1 row in set