达梦数据库生成guid字符串

1. 生成大写无横杠的guid

SELECT GUID () FROM DUAL;

2. 生成小写无横杠的guid

SELECT LOWER(GUID()) FROM DUAL;

3. 生成大写无横杠的guid

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

4. 生成小写无横杠的guid

SELECT SUBSTR(LOWER(GUID()),1,8)||'-'||SUBSTR(LOWER(GUID()),9,4)||'-'||SUBSTR(LOWER(GUID()),13,4)||'-'||SUBSTR(LOWER(GUID()),17,4)||'-'||SUBSTR(LOWER(GUID()),20,12) as guid FROM DUAL;