Friday, August 29, 2014

36 Character GUID generation in Oracle using SYS_GUID

SELECT REGEXP_REPLACE(sys_guid(), '(........)(....)(....)(....)(............)','\1-\2-\3-\4-\5') FROM DUAL;

No comments:

Post a Comment