GUID under Oracle - sys_guid pseudocolumn

Oracle GUID

You can use the new pseudocolumn SYS_GUID to populate a column; it has the advantage of being globally unique and doesn't require the sequence number or trigger overhead:

create table t5(id$ raw(16) default sys_guid()
constraint t5_pk primary key);
insert into t5(id$) values (default);
select * from t5;

ID$
——————————–
643718A07DCC43F2AC95312FD43617BA