Showing posts with label ORACLE. Show all posts
Showing posts with label ORACLE. Show all posts

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;