Support between different databases for GUID generation functions

In ms SQL Server, there is a NEWID function, the returned data type is UniqueIdentifier, length is 36.

Oracle has the SYS_GUID function. The returned data type is char and the length is 32.

In DB2, there is no GUID generation function, there is an alternative function generate_unique, the returned data type is char for bit, the length is 13.

SYBASE also has the NEWID () function. The returned data type is char and the length is 36.

Comment: GUID plays a very important role in ensuring the uniqueness of the Primary Key of data records. DB2 does not support this function, and DB2 is the worst among mainstream commercial databases. Ms SQL Server also has data types that directly support guids, which are best supported. SYBASE is the worst-performing document. The NEWID function cannot be found in its document, but it can be used.