UUID

Syntax

Description of the illustration uuid.gif

UUID returns a Version 4, Version 5, or Version 7 UUID as a RAW(16) value. By default, it returns a Version 4, variant 1 UUID. You can call UUID() without an argument or specify the version number explicitly.

UUID(0) and UUID(4) are equivalent to UUID().

You can optionally specify a version_specifier of NUMBER type. Oracle AI Database truncates a noninteger version_specifier to an integer.

To generate a Version 5 UUID, specify UUID(5, namespace, name). The namespace can be any RFC 9562-compliant UUID, including a version that UUID does not generate. You can pass it as a RAW value or a UUID string. For a predefined namespace, specify 'url', 'dns', 'oid', or 'x500' (case-insensitive) instead of its UUID value. The name must be a nonempty string.

The following statement generates a Version 5 UUID using the predefined DNS namespace:

SELECT RAW_TO_UUID(UUID(5, 'dns', 'www.example.com')) FROM DUAL;

UUID(7) generates a Version 7 UUID.

For example:

SELECT RAW_TO_UUID(UUID(7)) FROM DUAL;

Oracle AI Database raises an error for an unsupported version, invalid Version 5 input, or UUID generation failure.