Re: Generating SQLServer style GUID in Oracle 9

I am doing something like that, but I need to generate an unlimited # of SQLServer GUIDs to translate my data. It is a pain to do it this way.

So I am still looking for the magic reformat on the fly logic.

Bart

Galen Boyer wrote:
> On 18 Dec 2006, barthome1_at_comcast.net wrote:
> > 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.
>
> Sounds like the programmers really broke some data rules and found
> "intelligence" in the keys sent to them.
>
> Maybe you could create a translation table that houses the Oracle GUID
> as a column and ties you to the SQLServer GUID that gets generated by
> SQLServer?
>
> --
> Galen Boyer
Received on Wed Dec 20 2006 - 10:15:38 CST