Re: GUID's

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 16 Jul 2001 12:58:47 -0700
Message-ID: <9ivh1n0oso@drn.newsguy.com>

In article <3b532e71$1_8_at_news.newsgroups.com>, "Robert says...
>
>What support if any does Oracle provide for GUID's. Native datatype?
>Function to generate a GUID from within a stored procedure?
>
>

the type is RAW(16) (16 byte binary chunk of data)

The function is sys_guid()

scott_at_ORA815> select sys_guid() from dual;

SYS_GUID()

---

893C73A066EF2690E034080020884DD6

scott_at_ORA815> /

SYS_GUID()

---

893C73A066F02690E034080020884DD6

>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 

Received on Mon Jul 16 2001 - 14:58:47 CDT