oracle,使用SYS_GUID()生成32位唯一字符串
SELECT RAWTOHEX(SYS_GUID()) AS GUID_STRING FROM DUAL;
-- 插入数据时,使用RAWTOHEX转换SYS_GUID()生成的GUID
INSERT INTO my_table (id, data) VALUES (RAWTOHEX(SYS_GUID()), 'Some data');
SELECT RAWTOHEX(SYS_GUID()) AS GUID_STRING FROM DUAL;
-- 插入数据时,使用RAWTOHEX转换SYS_GUID()生成的GUID
INSERT INTO my_table (id, data) VALUES (RAWTOHEX(SYS_GUID()), 'Some data');