Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Generating SQLServer style GUID in Oracle 9
<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