Re: Oracle and the RowGuid

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 12 Nov 1999 10:09:09 -0500
Message-ID: <jS0sONqYqlQrQJm9v+weJ6F3GXoP@4ax.com>

A copy of this was sent to "fdefranco" <fdefranco_at_hrads.com> (if that email address didn't require changing) On Fri, 12 Nov 1999 09:06:09 -0500, you wrote:

>Does anyone know if Oracle supports the RowGuid datatype like MS SQL Server?
>This allows globally unique primary keys throughout a db, by using the NIC
>card of the server to create the keys?
>
>Thanks, Fred.
>

tkyte_at_8i> select sys_guid() from dual;

SYS_GUID()

---

58C4A6EE1C2005FFE034080020A767E0 sys_guid returns a globally unique identifier in a 16 byte raw field (above is in hex).

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Nov 12 1999 - 09:09:09 CST