Oracle x SQL

[Jorge Pinto]

Hi Folks,

I have some stored procedures in Sql and I'm migrating those to Oracle. I
didn't find one with the same idea as DIFFERENCE in SQL. If you don't know
what is the function of difference, I'm explaining....
DIFFERENCE
Returns the difference between the SOUNDEX values of two character
expressions as an integer.

Anyone know if we have a function with the same functionality as this one
above in Oracle ??

Thanks in Advance,

Jorge

[Chris Leonard]

Hello Jorge,

The SOUNDEX function in Oracle will return the same values as the SOUNDEX
function in SQL Server. To see how to use SOUNDEX to compute the DIFFERENCE
function, see
http://support.microsoft.com/default...NoWebContent=1.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Jorge Pinto" <jo****@sympatico.ca> wrote in message
news:GA*****************@news20.bellglobal.com...

Hi Folks,

I have some stored procedures in Sql and I'm migrating those to Oracle. I
didn't find one with the same idea as DIFFERENCE in SQL. If you don't know
what is the function of difference, I'm explaining....
DIFFERENCE
Returns the difference between the SOUNDEX values of two character
expressions as an integer.

Anyone know if we have a function with the same functionality as this one
above in Oracle ??

Thanks in Advance,

Jorge

[Jim Kennedy]

"Jorge Pinto" <jo****@sympatico.ca> wrote in message
news:GA*****************@news20.bellglobal.com...

Hi Folks,

I have some stored procedures in Sql and I'm migrating those to Oracle. I
didn't find one with the same idea as DIFFERENCE in SQL. If you don't know
what is the function of difference, I'm explaining....
DIFFERENCE
Returns the difference between the SOUNDEX values of two character
expressions as an integer.

Anyone know if we have a function with the same functionality as this one
above in Oracle ??

Thanks in Advance,

Jorge

Please, if you are going to refer to SQL Server then refer to SQL Server and
not SQL. SQL stands for structured query language and is a language not a
server.
Jim