Oracle用function生成UUID方法
[code="sql"]
CREATE OR REPLACE FUNCTION get_uuid
RETURN VARCHAR
IS
guid VARCHAR (50);
BEGIN
guid := lower(RAWTOHEX(sys_guid()));
RETURN
substr(guid,1,8)||'-'||substr(guid,9,4)||'-'||substr(gui...
原创
2013-04-02 10:14:32 ·
406 阅读 ·
0 评论