Oracle SQL: the Essential Reference

SYS_GUID

SYS_GUID( )

Returns a 16-byte RAW value that can be used as a globally unique identifier. On most platforms, the value is a combination of the host ID, a process (or thread) ID, and a sequence number.

RAW values are converted to hexadecimal when displayed by SQL*Plus, so in the example, 32 rather than 16 characters are displayed in the result, since each character has been displayed using two hexadecimal digits.

Example

SQL> SELECT SYS_GUID(  ) FROM dual;

SYS_GUID(  )
--------------------------------

6827BA0C1CF2D067E0300B0A100C0246

Unlike other functions, SYSGUID must be followed with parentheses even though no parameters are passed.