您的位置: 首页  >  IT文章  >  Oracle生成GUID

Oracle生成GUID

分类: IT文章 • 2022-03-31 14:06:17

Oracle生成GUID

SELECT SUBSTR(GUID,1,8)||'-'||SUBSTR(GUID,9,4)||'-'||SUBSTR(GUID,13,4)||'-'||SUBSTR(GUID,17,4)||'-'||SUBSTR(GUID,20,12) GUID
FROM 
(
    SELECT SYS_GUID() GUID  FROM DUAL
)

相关推荐