"Oracle Unique PRIMARY Key Sys_guid ()"

the previous blog introduced the use of sequences and triggers to implement the self-increment primary key, mainly to avoid the occurrence of the same primary key and error.

now let's introduce another clock to prevent the same method as the primary key.

Unique PRIMARY Key

UseSys_guid () generates a unique encoding of 32 bits. To generate a unique primary key

For example:

CREATE TABLE Test
(ID Raw (+) default Sys_guid () primary key,filler varchar2 (+))

This makes it possible to generate a unique primary key ID, without inserting the ID column when inserting the data.

"Oracle Unique PRIMARY Key Sys_guid ()"