Re: Robust unique identifiers?

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sun, 23 Jan 2005 17:31:03 +0100
Message-ID: <14k7v0ll1apsamm1d76j3fce0gtvmqd75j@4ax.com>

On 23 Jan 2005 08:22:47 -0800, "Jining Han" <jining.han_at_gmail.com> wrote:

>Look into GUID? Of course SQL Server and Oracle have some differences
>there, but not irreconcilable in my opinion
>
>Good luck
>Jining Han

so what differences, do you think, are reconcilable? Guids are stored as RAW(16) and RAW(16) is only treated as RAW(16) in pl/sql. Everywhere else it is treated as VARCHAR2, forcing implicit conversion, preventing the use of indexes!!!!!!!!

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Jan 23 2005 - 10:31:03 CST