Oracle equivalent to SS7 "uniqueidentifier"?

From: Richard Crawford <rscrawford.penguin_at_mossroot.remove_waterfowl.com>
Date: Mon, 02 Feb 2004 14:49:17 -0800
Message-ID: <bvmk5i$5m4$1@woodrow.ucdavis.edu>

The database which I am migrating in our office from MS SQL Server 7 to Oracle has a table which includes a field of type "uniqueidentifier". As far as I can tell, the purpose of this type is to make a row in that table absolutely unique within the entire database and not just unique within the table. The field contains strings like, "B289DA02-B9B3-11D4-9DCD-00D0B79147DF". This wouldn't bother me ordinarily, but the values in this field are being used to key to other rows in other tables. When a new record is created in the database, it needs to have a field like this.

I doubt that there's any equivalent to this field type in Oracle, and I can't see a need for it, but it's a big obstacle for me.

Does anyone have any suggestions for how to get around this problem? Received on Mon Feb 02 2004 - 16:49:17 CST