Oracle 生成带 "-" GUID

来源:互联网 发布:vscode vue 开发环境 编辑:程序博客网 时间:2024/06/03 16:02
SELECT SUBSTR(GUID,1,8)||'-'||SUBSTR(GUID,9,4)||'-'||SUBSTR(GUID,13,4)||'-'||SUBSTR(GUID,17,4)||'-'||SUBSTR(GUID,20,12) GUIDFROM (    SELECT SYS_GUID() GUID  FROM DUAL)



如果要生成不带 "-" 的GUID,可直接用 SYS_GUID()

SELECT SYS_GUID() GUID  FROM DUAL


0 0