Re: Storing GUIDs in Oracle

From: Maximus <qweqwe_at_qwqwewq.com>
Date: Wed, 23 Jul 2003 15:09:59 GMT
Message-ID: <bzxTa.523341$Vi5.13452754@news1.calgary.shaw.ca>

"Jeff Boenig" <jeff.boenig_at_elsitech.com> wrote in message news:3f1e9642$1_at_btitelecom.net...
> I'm developing a .NET application that will support both MS SQL Server and
> Oracle 9i and above. I want to use GUIDs as the primary key in several
> tables. MS SQL supports this nicely using the UNIQUEIDENTIFIER data type.
> The ADO.NET OleDb data provider automatically converts it to a
System.Guid.
>
> Is it possible to store GUIDs in Oracle databases? There doesn't appear
to
> be a GUID data type in Oracle 9i. Could I store it as RAW(16)? If I do,
> would I be able to create an index on that column? Does Oracle 10i have
> support for GUID?

Load the Oracle SQL reference into Adobe Acrobat, search for "GUID."

Why are so many programmers completely useless at doing basic research?

Yes I'm flaming you. Received on Wed Jul 23 2003 - 10:09:59 CDT