Re: Generating SQLServer style GUID in Oracle 9

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 18 Dec 2006 20:02:27 +0100
Message-ID: <4586E5C3.7040603@gmail.com>

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.
>
> Bart
>
>

That may be very difficult task if one consider lack of string manipulation functions in Oracle... ( no LEFT, no RIGHT, no MIDDLE)

Best regards

Maxim
(sorry, couldn't resist) Received on Mon Dec 18 2006 - 13:02:27 CST

This message: [ Message body ]
Next message: hpuxrac: "Re: ORA-1555 snapshot too old: why?"
Previous message: DA Morgan: "Re: ORA-1555 snapshot too old: why?"
In reply to: barthome1_at_comcast.net: "Re: Generating SQLServer style GUID in Oracle 9"
Next in thread: Serge Rielau: "Re: Generating SQLServer style GUID in Oracle 9"
Reply: Serge Rielau: "Re: Generating SQLServer style GUID in Oracle 9"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US