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
)

 

posted @ 2019-04-26 16:38  清狐  阅读(16719)  评论(0)  编辑  收藏  举报