Re: Generating SQLServer style GUID in Oracle 9

From: <barthome1_at_comcast.net>
Date: 18 Dec 2006 12:48:45 -0800
Message-ID: <1166474925.247370.224240@48g2000cwx.googlegroups.com>

Okay Serge, I will see how good my Oracle skills are and try this. Our REAL GOOD Oracle developer is off this week. I am going have to wing it.

Bart

Serge Rielau wrote:
> Maxim Demenko wrote:
> > barthome1_at_comcast.net schrieb:
> >>
> >>
> >> 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.
> > That may be very difficult task if one consider lack of string
> > manipulation functions in Oracle... ( no LEFT, no RIGHT, no MIDDLE)
> SUBSTR() should be plenty enough. All '-' positions are fixed for GUUID.
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
>
> WAIUG Conference
> http://www.iiug.org/waiug/present/Forum2006/Forum2006.html
Received on Mon Dec 18 2006 - 14:48:45 CST