存储过程 产生 UUID
CREATE OR REPLACEFUNCTION get_uuidRETURN VARCHARISguid VARCHAR (50);BEGINguid := lower(RAWTOHEX(sys_guid()));RETURNsubstr(guid,1,8)||substr(guid,9,4)||substr(guid,13,4)||substr(guid,17,4)||substr(guid,21,12);END get_uuid;
?
发布时间： 2012-08-14 10:39:58 作者： rapoo
存储过程 产生 UUID
CREATE OR REPLACEFUNCTION get_uuidRETURN VARCHARISguid VARCHAR (50);BEGINguid := lower(RAWTOHEX(sys_guid()));RETURNsubstr(guid,1,8)||substr(guid,9,4)||substr(guid,13,4)||substr(guid,17,4)||substr(guid,21,12);END get_uuid;
?