UUID

Syntax


Description of uuid.eps follows
Description of the illustration uuid.eps

UUID returns a version 4 variant 1 UUID as a RAW(16) value in the format:

xxxxxxxx-xxxx-4xxx-Bxxx-xxxxxxxxxxxx where x is a hexadecimal digit.

UUID can optionally take as input a version_specifier of NUMBER type. UUID(0) and UUID(4) are equivalent to UUID() in that in both cases a version 4 variant 1 UUID is returned.

Versions other than 4 and 0 return an error.

Example

SELECT UUID() from dual;

The output is:

UUID()

--------------------------------

848DC57A12AA4F81BFB42EA509879467

Note: RAW(16) is converted into printable form.