Background ----------------- 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;