Uuid function retrieved from Oracle Database

When creating a system table in Oracle, the primary key must be a 32-bit uuid. It is assumed that Oracle will certainly provide related functions.

When creating a system table in Oracle, the primary key must be a 32-bit uuid. It is assumed that Oracle will certainly provide related functions.

When creating a system table in Oracle, the primary key must be a 32-bit uuid. It is assumed that Oracle will certainly provide related functions.

After reading the relevant documents, we found that the sys_guid () function provided by Oracle is used to obtain a 32-bit uuid.

Select sys_guid () from dual;

This function returns 32-bit uuid in upper case. You can use lower (sys_guid () to convert it to lower case.

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

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

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