Orcale中生成UUID

--生成一个跟MAC地址、生成时间相关的一个32位16进制的随机数。数据类型是 raw(16) 有32个字符。
select sys_guid() from dual;
--生成一个标准的UUID
CREATE OR REPLACE
FUNCTION get_uuid
RETURN VARCHAR
IS
guid VARCHAR (50);
BEGIN
guid := lower(RAWTOHEX(sys_guid()));
RETURN
substr(guid,1,8)||'-'||substr(guid,9,4)||'-'||substr(guid,13,4)||'-'||substr(guid,17,4)||'-'||substr(guid,21,12);
END get_uuid;
 
select get_uuid from dual ;