[OrAcLe] UUID 생성

 

 

-- 36자리 UUID

SQL> SELECT REGEXP_REPLACE(RAWTOHEX(SYS_GUID()), '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})', '\1-\2-\3-\4-\5') AS UUID FROM DUAL;

 

UUID
--------------------------------------------------------------------------------
038DA18C-2A8B-4557-E063-7A28A8C02165

 

 

 

-- 32자리 UUID

SQL> SELECT REGEXP_REPLACE(RAWTOHEX(SYS_GUID()), '([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})', '\1\2\3\4\5') AS UUID FROM DUAL;

UUID
--------------------------------------------------------------------------------
038DB3A323D70D1DE0637A28A8C03507