生成大写无横杠的guid
SELECT SYS_GUID() as guid FROM DUAL
生成小写无横杠的guid
SELECT lower(SYS_GUID()) as guid FROM DUAL
生成小写带横杠的guid
SELECT SUBSTR(lower(SYS_GUID()),1,8)||'-'||SUBSTR(lower(SYS_GUID()),9,4)||'-'||SUBSTR(lower(SYS_GUID()),13,4)||'-'||SUBSTR(lower(SYS_GUID()),17,4)||'-'||SUBSTR(lower(SYS_GUID()),20,12) as guid FROM DUAL
生成大写带横杠的guid
SELECT SUBSTR(SYS_GUID(),1,8)||'-'||SUBSTR(SYS_GUID(),9,4)||'-'||SUBSTR(SYS_GUID(),13,4)||'-'||SUBSTR(SYS_GUID(),17,4)||'-'||SUBSTR(SYS_GUID(),20,12) as guid FROM DUAL