RAW_TO_UUID

Syntax

Description of the illustration raw_to_uuid.gif

RAW_TO_UUID converts the input argument uuid_string into canonical format of 36 bytes which consists of 32 hexadecimal bytes and 4 hyphens. uuid_string must be of datatype RAW(16).

If the input is NULL, it returns NULL.

Example

SELECT RAW_TO_UUID(UUID()) FROM DUAL;

The output is:

RAW_TO_UUID(UUID())
------------------------------------
81f9b934-5028-4f8c-bf05-f082e9b72e0f