Oracle中的UUID()

Sway_F

于 2022-06-15 09:40:44 发布

阅读量1.4k

点赞数

文章标签： oracle 数据库 database

本文链接：https://blog.youkuaiyun.com/Sway_F/article/details/124882662

版权

CREATE OR REPLACE FUNCTION "UUID"
    RETURN VARCHAR2
IS
    sysGuid VARCHAR2(38);
BEGIN
    SELECT (Substr(guid, 1, 8) || '-' || Substr(guid, 9, 4) || '-' ||
            Substr(guid, 13, 4) || '-' || Substr(guid, 17, 4) || '-' ||
            Substr(guid, 17, 12)) INTO sysGuid
    FROM (SELECT sys_guid() guid
          FROM Dual);
    RETURN sysGuid;
END;

创建UUID()方便使用，记录一下

总结日常用到的小东西