uuid函数

CREATE OR REPLACE function get_uuid
returns guid nvarchar(36)
language sqlscript as
begin
guid := lower(SYSUUID);
guid :=substring(guid,1,8)||'-'||substring(guid,9,4)||'-'||substring(guid,13,4)||'-'||substring(guid,17,4)||'-'||substring(guid,21,12);
end;

SELECT get_uuid() FROM dummy;

posted @ 2020-12-25 12:13  可控核聚变  阅读(129)  评论(0)    收藏  举报