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]

Re: Oracle x SQL

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" <jorgep@sympati co.cawrote in message
news:GAO6b.507$ Nx6.84824@news2 0.bellglobal.co m...

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]

Re: Oracle x SQL

"Jorge Pinto" <jorgep@sympati co.cawrote in message
news:GAO6b.507$ Nx6.84824@news2 0.bellglobal.co m...

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