oracle 创建 UUID

项目已经上线，丢出来供大家参考 

create 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;

如果想用java生成唯一ID，可参考

https://blog.csdn.net/qq_35193093/article/details/88575477