Printable View
I am trying to use a function that will generate a unique identifier GUID in this format "{08000000-0000-0000-0000-000000000000}".
I believe that such a function exists in Oracle 8i and up.
Does anyone have an idea what this function is called and where I can find more information about it and what it does?
Function that can generate Microsoft GUID for OLE in oracle doesn't exists.
U should use some MS products for generate GUID.
Oracle works not only in MS platform.
use this query
select sys_guid() from dual;
use this query
select '{'||substr(sys_guid(),1,8)||'-'||substr(sys_guid(),9,4)||'-'
||substr(sys_guid(),13,4)||'-'||substr(sys_guid(),17,4)||'-'
||substr(sys_guid(),20)||'}' from dual
select sys_guid() from dual;
SYS_GUID()
--------------------------------
9F3B753A5D502819E0301FAC1EC83A1A
SYS_GUID generates and returns a globally unique identifier (RAW value) made up of 16 bytes. On most platforms, the generated identifier consists of a host identifier and a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.
This is not GUID for OLE -->"{08000000-0000-0000-0000-000000000000}".
