8) trim(): This function removes the white spaces from both left and right hand side of the given string Ex: select trim(' Welcomt To Ashok IT Hyderabad ') from dual; select length(' Welcomt To Ashok ...

Oracle SQL string functions have included the Soundex function for a long time. Soundex is a phonetic normalization function that was invented for the 1880 U.S. Census to get around the problem of ...