Sponsored Links
Oracle SIGN , SOUNDEX functions
Oracle SIGN(n) positive = 1, zero = 0, negative = -1 , Powerful comparison function
select SIGN(12-11) from dual
Result :1
select SIGN(12-12) from dual
Result :0
select SIGN(-12-0) from dual
Result : -1
SOUNDEX(char) Returns a char value representing the sound of the words
select SOUNDEX('whyte') from dual
result:W300
select SOUNDEX('knowledge') from dual
result: K543
Page 1
|
| 
