How to create UUID inside Oracle

For the reason of unique identification of records in a database normally a unique integer value is sufficient. However, if records shall be exchange between databases a globally unique identification is required. UUIDs would be nice. But they shall be not created in a database Client but automatically inside the database.

Taggings:

Submitted by Roland Willmann on Thu, 12/19/2013 - 16:48
1 answer

Usage of SYS_GUID function

The function SYS_GUID of oracle databases provides this functionality. It can be applied according to the following example

SELECT SYS_GUID() FROM dual;

Submitted by Roland Willmann on Thu, 12/19/2013 - 16:49