Re: GUID Fields in Oracle

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 18 Jun 2001 22:23:10 -0700
Message-ID: <3B2EE1BD.4721F7AA@exesolutions.com>

Jim Kennedy wrote:

> Just store it in a varchar2 field.
> Jim
> "rbc" <astrobran_at_yahoo.com> wrote in message
> news:JIpX6.75349$r4.828733_at_e420r-atl3.usenetserver.com...
> > In SQL Server, there is a GUID datatype that we use in our replication.
> > However, we need to determine the feasibility of Oracle as a back end for
> > some customers. In this case, we need to be able to store the GUIDs as we
> > currently do and also allow those fields to be used in replication.
> > Is this possible in Oracle and, if so, what datatype would be used since I
> > haven't seen mention of a GUID datatype in Oracle.
> >
> > FYI, using Oracle 8i (8.1.7)
> >
> > Thanks,
> > Brandon
> >
> >
> >
> >

GUIDs in Oracle are meant to be stored in a field of type RAW(16).

Daniel A. Morgan Received on Tue Jun 19 2001 - 00:23:10 CDT