SOUNDEX This will be used to find words that sound like other words, exclusively used in where clause. This function return the values whose pronunciation as some but spell differently.Syntax:…
REPLACE This will replace the set of characters, string by string.To replace multiple character at a time. Syntax: replace (string, old_chars [, new_chars]) Ex: select replace('india','in','xy'), replace('india','in') from dual; output…
TRANSLATE This will replace the set of characters, character by character.To replace the single character at a time. Syntax: translate (string, old_chars, new_chars) Ex: select translate('india','in','xy') from dual; output translate('india','in','xy')…