lzm1996 2018-09-29 09:52:45

oracle UUID生成,带横岗。

--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;

评论

首页 - Wiki
Copyright © 2011-2024 iteam. Current version is 2.137.1. UTC+08:00, 2024-11-21 23:53
浙ICP备14020137号-1 $访客地图$