Oracle SYS_GUID() Function

Oracle SYS_GUID() is a built-in function that generates and returns a globally unique identifier composed of 16 bytes.

Oracle SYS_GUID() Syntax

Here is the syntax for the Oracle SYS_GUID() function:

SYS_GUID()

Parameters

The Oracle SYS_GUID() function does not require any parameters.

Return Value

The Oracle SYS_GUID() function returns a globally unique identifier composed of 16 bytes.

On most platforms, the generated identifier is composed of the host identifier, the process or thread identifier of the calling function, and a non-repeating value (a byte sequence) for that process or thread.

Oracle SYS_GUID() Examples

The following statement uses the Oracle SYS_GUID() function to return a GUID.

SELECT
    SYS_GUID()
FROM dual;

Output:

SYS_GUID()
___________________________________
BCC2977F37F946909B3C9CEB6F680C69

Here’s another example:

SELECT SYS_GUID() FROM dual
UNION ALL
SELECT SYS_GUID() FROM dual
UNION ALL
SELECT SYS_GUID() FROM dual
UNION ALL
SELECT SYS_GUID() FROM dual
UNION ALL
SELECT SYS_GUID() FROM dual;

Output:

SYS_GUID()
___________________________________
75A278AA87644CEAA59DF7B4B245F26E
DBA9112A288D4072938A8F247A4D435E
0E8F297A5C514474812645CD31D953C7
1CAB8C4F76424882BD8B55DC2C7BCFFC
BD61A6B6803845D3A8F8C3BAC6F0714C

Conclusion

Oracle SYS_GUID() is a built-in function that generates and returns a globally unique identifier composed of 16 bytes.

You can find more information about this function here.