SQL Server uniqueidentifier cast to binary...what is equivalent in Oracle?
Hi,
I am having trouble understanding equivalent data types in my conversion from SQL Server to Oracle.
Let's say I have this statement in SQL Server, where the string being "passed in" is a uniqueidentifier:
select cast(substring('EFDA8997-63AA-4F33-96CF-29BFC2CE252E',8,1) as binary(1));
The tool I've used to convert this to Oracle says the equivalent statement to this is (where the string being "passed in" is a char:
select cast((substr('EFDA8997-63AA-4F33-96CF-29BFC2CE252E',8,1)) as raw(1)) from dual;
However, I get different results when testing these two statements:
SQL Server: 0x37
Oracle: 07
What is the correct what to convert this statement to Oracle?
Thank you!
Mimi