Re: Generating SQLServer style GUID in Oracle 9

The situation has moved on a bit since I first posted the question. I understand now that the two sets of output are essentially the same. The wrinkle is that the when you convert the Oracle GUID RAW (using a function like RAWTOHEX) the output is one continues string. The SQLServer format is formatted with dashes to break up the string.

 The problem is that the output from this process is an XML file that is sent through an in-house loader that requires the GUID to be in the format the SQLlikes. I can not get the powers-that-be to see the value of putting into this program avconversion from the ORACLE format to the SQLServer format.

So now I need to find a way to take the ORACLE GUID format and convert it to the SQLServer format within a SQL select statement.

Bart

David Portas wrote:
> barthome1_at_comcast.net wrote:
> > 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
> >
>
> Both return a 16 byte identifier. What is your problem?
>
> --
> David Portas
Received on Mon Dec 18 2006 - 12:40:01 CST