mssql,mysql,Oracle 数据库中获得UUID字符串

sql server : select replace(newId(),'-','')

oracle :select sys_guid() from dual

1 SQL> select sys_guid() from dual;
2 SYS_GUID()
3 --------------------------------
4 74CC7FA2ABF7437D9AC29798ACC3E129
5 
6 SQL>

mysql :UUID()

　　JAVA 中获取UUID

 1 import java.util.UUID;
 2 
 3 import org.junit.Test;
 4 
 5 public class getUUID {
 6     @Test
 7     public void getUuid(){
 8         UUID u = UUID.randomUUID();
 9         System.out.println(u.toString().replace("-", ""));
10     }
11 }