Re: Generating SQLServer style GUID in Oracle 9

From: <ThomasO_at_cpas.com>
Date: 15 Dec 2006 14:18:06 -0800
Message-ID: <1166221086.231005.286340@n67g2000cwd.googlegroups.com>

On Dec 15, 4:38 pm, bartho..._at_comcast.net wrote:
> I am having to extract data from Oracle to be loaded, through a text
> output file, into SQLServer. One of the data items I must tag each
> output value with is a SQLServer style GUID. Is there a way to have
> Oracle generate this type of GUID?
>
> Bart

Bart,
Look up function SYS_GUID()
at:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions168.htm

Maybe this is what you are looking for.
HTH
Thomas Received on Fri Dec 15 2006 - 16:18:06 CST