Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Generating SQLServer style GUID in Oracle 9

Re: Generating SQLServer style GUID in Oracle 9

From: Jim Kennedy <jim>
Date: Fri, 15 Dec 2006 19:45:32 -0800
Message-ID: <FJidneyNg8xs9x7YnZ2dnUVZ_sOknZ2d@comcast.com>

<barthome1_at_comcast.net> wrote in message news:1166224214.966714.193930_at_16g2000cwy.googlegroups.com...
> A co-worker, who knows a whole lot more about Oracle than I, looked at
> this and thought that there was some difference between this and the
> SQLServer GUID.
>
> Does anyone have a comment on this angle?
>
> Bart
>
> David Portas wrote:
> > barthome1_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
> >
> > Lookup SYS_GUID()
> >
> > --
> > David Portas
>

What is your business requirement? What difference does it make if the two GUIDs are somehow calculated or constructed in different ways? As long as they meet the business requirement. (some globally unique id) Jim Received on Fri Dec 15 2006 - 21:45:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US