Home Topic library logo Library Mine
More

lzm1996 2018-09-29 09:52:45

oracle UUID生成，带横岗。

sql sql 
--oracle UUID自动生成，带横岗：
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 "UUID(32位带横岗8,4,4,4,12)"
  FROM dual;

评论

Home - Wiki
Copyright © 2011-2025 iteam. Current version is 2.146.0. UTC+08:00, 2025-08-29 09:12
浙ICP备14020137号-1 $Map of visitor$