Re: Generating SQLServer style GUID in Oracle 9

On 20 Dec 2006, barthome1_at_comcast.net wrote:
> 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.

Why can't you ask SQLServer to give you a new GUID, tie that to the string from Oracle, store it in the translation table and then be done with it?

-- 
Galen Boyer