惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

WordPress大学
WordPress大学
F
Fortinet All Blogs
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
S
Secure Thoughts
SecWiki News
SecWiki News
Hacker News: Ask HN
Hacker News: Ask HN
Google DeepMind News
Google DeepMind News
N
Netflix TechBlog - Medium
Recorded Future
Recorded Future
Hacker News - Newest:
Hacker News - Newest: "LLM"
Webroot Blog
Webroot Blog
Cloudbric
Cloudbric
博客园 - 司徒正美
The Cloudflare Blog
W
WeLiveSecurity
T
Tailwind CSS Blog
V2EX - 技术
V2EX - 技术
H
Heimdal Security Blog
Jina AI
Jina AI
MyScale Blog
MyScale Blog
S
SegmentFault 最新的问题
Apple Machine Learning Research
Apple Machine Learning Research
雷峰网
雷峰网
罗磊的独立博客
H
Hackread – Cybersecurity News, Data Breaches, AI and More
Project Zero
Project Zero
C
CXSECURITY Database RSS Feed - CXSecurity.com
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
博客园 - 【当耐特】
Forbes - Security
Forbes - Security
Last Week in AI
Last Week in AI
G
GRAHAM CLULEY
C
Check Point Blog
P
Proofpoint News Feed
L
LINUX DO - 最新话题
博客园 - Franky
P
Proofpoint News Feed
T
Tor Project blog
S
Security @ Cisco Blogs
Hugging Face - Blog
Hugging Face - Blog
阮一峰的网络日志
阮一峰的网络日志
J
Java Code Geeks
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
宝玉的分享
宝玉的分享
C
Cyber Attacks, Cyber Crime and Cyber Security
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
O
OpenAI News
小众软件
小众软件
云风的 BLOG
云风的 BLOG
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报

博客园 - Anson2020

SQL Server 清除数据库日志脚本 让 Firefox 也支持 outerHTML StringSplitOptions Enumeration [转] - Anson2020 Hibernate映射类型对照表 [转] 解决 .setAttribute 添加JS或者CSS 在IE下不起作用. - Anson2020 Internet Explorer 8 Beta 1 已发布并提供下载! Eclipse编写代码可以设置源文件的编码方式UTF-8 [转] .NET 实战SSL安全加密机制 [转] IE Firefox css 差别 [转] 关于Service Unavailable的解决方法 [转] 解决JavaME中的内存泄漏 [转] 转载(正则表达式) [转] ORACLE Text 文本检索 Ajax Tree 仿Google和Windows Live的JS+DIV Drag [转] Input的高级用法11例 Asp.Net避免按钮重复点击(转) [转] ASP.NET 缓冲: 技术及最佳实践 [转] 支付宝Payto接口的c#.net实现
Oracle 生成 GUID 类型 [转]
Anson2020 · 2008-04-08 · via 博客园 - Anson2020

CREATE OR REPLACE FUNCTION AILDM_GET_GUID
   
RETURN CHAR
IS
   v_guid              
CHAR (36);
   v_guid_part_one     
CHAR (8);
   v_guid_part_two     
CHAR (4);
   v_guid_part_three   
CHAR (4);
   v_guid_part_four    
CHAR (4);
   v_guid_part_five    
CHAR (12);
BEGIN
   
SELECT SYS_GUID ()
     
INTO v_guid
     
FROM DUAL;

   v_guid_part_one :

= SUBSTR (v_guid, 08);
   v_guid_part_two :
= SUBSTR (v_guid, 84);
   v_guid_part_three :
= SUBSTR (v_guid, 124);
   v_guid_part_four :
= SUBSTR (v_guid, 164);
   v_guid_part_five :
= SUBSTR (v_guid, 2012);
   v_guid :
=
      CONCAT
         (CONCAT
             (CONCAT
                 (CONCAT (CONCAT (CONCAT (CONCAT (CONCAT (v_guid_part_one,
                                                          
'-'),
                                                  v_guid_part_two
                                                 ),
                                          
'-'
                                         ),
                                  v_guid_part_three
                                 ),
                          
'-'
                         ),
                  v_guid_part_four
                 ),
              
'-'
             ),
          v_guid_part_five
         );
   
RETURN (v_guid);
END AILDM_GET_GUID;