Oracle用function生成UUID方法CREATE OR REPLACE FUNCTION get_uuidRETURN VARCHARISguid VARCHAR (50)BE
Oracle用function生成UUID方法
CREATE OR REPLACE FUNCTION 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;