Purpose
RAWTOHEX() converts a binary string to a hexadecimal representation.
Syntax
RAWTOHEX(raw)
Parameters
| Parameter | Description |
|---|---|
| raw | A binary string. |
Return type
This function returns a hexadecimal representation.
Examples
The following example converts the binary value AB to a hexadecimal representation.
obclient> SELECT RAWTOHEX('AB') FROM DUAL;
+----------------+
| RAWTOHEX('AB') |
+----------------+
| 4142 |
+----------------+
1 row in set