SELECT SUBSTR(GUID,1,8)||'-'||SUBSTR(GUID,9,4)||'-'||SUBSTR(GUID,13,17,20,12) GUID
FROM
(
SELECT SYS_GUID() GUID FROM DUAL
)
如果要生成不带 "-" 的GUID，可直接用 SYS_GUID()
SELECT SYS_GUID() GUID FROM DUAL
SELECT SUBSTR(GUID,1,8)||'-'||SUBSTR(GUID,9,4)||'-'||SUBSTR(GUID,13,17,20,12) GUID
FROM
(
SELECT SYS_GUID() GUID FROM DUAL
)
如果要生成不带 "-" 的GUID，可直接用 SYS_GUID()
SELECT SYS_GUID() GUID FROM DUAL
