UTL_RAW

The UTL_RAW package provides SQL functions for manipulating RAW data types.

Table 7-12 describes the UTL_RAW subprograms.

Table 7-12 UTL_RAW Subprograms

Subprogram	Description
`BIT_AND` function	Performs bitwise logical "and" of two `RAW` values and returns the resulting `RAW`.
`BIT_COMPLEMENT` function	Performs bitwise logical "complement" of a `RAW` value and returns the resulting `RAW`.
`BIT_OR` function	Performs bitwise logical "or" of two `RAW` values and returns the resulting `RAW`.
`BIT_XOR` function	Performs bitwise logical "exclusive or" of two `RAW` values and returns the resulting `RAW`.
`CAST_FROM_BINARY_DOUBLE` function	Returns the `RAW` binary representation of a `BINARY_DOUBLE` value.
`CAST_FROM_BINARY_FLOAT` function	Returns the `RAW` binary representation of a `BINARY_FLOAT` value.
`CAST_FROM_BINARY_INTEGER` function	Returns the `RAW` binary representation of a `BINARY_INTEGER` value.
`CAST_FROM_NUMBER` function	Returns the `RAW` binary representation of a `NUMBER` value.
`CAST_TO_BINARY_DOUBLE` function	Casts the `RAW` binary representation of a `BINARY_DOUBLE` value into a `BINARY_DOUBLE`.
`CAST_TO_BINARY_FLOAT` function	Casts the `RAW` binary representation of a `BINARY_FLOAT` value into a `BINARY_FLOAT`.
`CAST_TO_BINARY_INTEGER` function	Casts the `RAW` binary representation of a `BINARY_INTEGER` value into a `BINARY_INTEGER`.
`CAST_TO_NUMBER` function	Casts the `RAW` binary representation of a `NUMBER` value into a `NUMBER`.
`CAST_TO_NVARCHAR2` function	Casts a `RAW` value represented using `n` data bytes into an `NVARCHAR2` value with `n` data bytes.
`CAST_TO_RAW` function	Casts a `VARCHAR2` value represented using `n` data bytes into a `RAW` with `n` data bytes.
`CAST_TO_VARCHAR2` function	Casts a `RAW` value represented using `n` data bytes into a `VARCHAR2` value with `n` data bytes.
`COMPARE` function	Compares two `RAW` values.
`CONCAT` function	Concatenates up to 12 `RAW` values into a single `RAW` value.
`CONVERT` function	Converts a `RAW` value from one character set to another and returns the resulting `RAW`.
`COPIES` function	Copies a `RAW` value a specified number of times and returns the concatenated `RAW` value.
`LENGTH` function	Returns the length in bytes of a `RAW` value.
`OVERLAY` function	Overlays the specified portion of a target `RAW` value with an overlay `RAW` value, starting from a specified byte position and proceeding for a specified number of bytes.
`REVERSE` function	Reverses a byte-sequence in a `RAW` value.
`SUBSTR` function	Returns a substring of a `RAW` value for a specified number of bytes from a specified starting position.
`TRANSLATE` function	Translates the specified bytes from an input `RAW` value according to the bytes in a specified translation `RAW` value.
`TRANSLITERATE` function	Converts the specified bytes from an input `RAW` value according to the bytes in a specified transliteration `RAW` value.
`XRANGE` function	Returns a `RAW` value containing the succession of one-byte encodings beginning and ending with the specified byte-codes.