CAST_FROM_BINARY_FLOAT

The CAST_FROM_BINARY_FLOAT function returns the BINARY_FLOAT value in RAW binary format.

Syntax

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

Parameters

Return value

The binary representation of the BINARY_FLOAT value in RAW format.

Considerations

• The following table 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 specifies how the bytes of the BINARY_FLOAT value are mapped to the bytes of the RAW value, as shown in the following matrix. In the matrix, rb0 ~ rb3 represent the bytes in the RAW value, and fb0 ~ fb3 represent the bytes in the BINARY_FLOAT value.

  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 directly copied to the RAW return value. If you specify big_endian on a big-endian system or little_endian on a little-endian system, the effect is the same.

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