René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

SYS_GUID

sys_guid()
sys_guid generates a unique value of 16 bytes. The returned datatype is RAW(16). 
SQL> select sys_guid() from dual;
 
 SYS_GUID()
 --------------------------------
 961622BC564946AB92D7B237B4AC414A