How to compare two strings

This allows you to find the difference between two strings by using a single SQL statement

The code is shown below :

SELECT ltrim(rtrim(translate(string2,string1,rpad(‘ ‘,length(string1))))) from dual;