Function to generate GUID a unique identifier

[dbarookie]

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?

[Shestakov]

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.

[rocpg]

use this query

select sys_guid() from dual;

[rocpg]

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

[Shestakov]

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}".