Richard Crawford wrote:
> 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?
look up SYS_GUID() in the docs
Received on Mon Feb 02 2004 - 16:57:26 CST
