Oracle中的UUID()

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()方便使用，记录一下

总结日常用到的小东西