Function to generate GUID a unique identifier
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Function to generate GUID a unique identifier

  1. #1
    Join Date
    Mar 2002
    Posts
    25

    Question

    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?

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  3. #3
    Join Date
    Apr 2002
    Posts
    2
    use this query

    select sys_guid() from dual;

  4. #4
    Join Date
    Apr 2002
    Posts
    2
    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

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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}".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width