Skip to content
Advertisement

Tag: oracle-fusion-apps

How to return the difference between 2 strings using Oracle SQL only

I have 2 strings for example: ‘Source:Siebel; Name:Mary Jane; Gender:F; Age:24; N;’ ‘Source:Siebel; Name:Marie; Gender:F; Age:24; N;’ The result I need is: Name:Mary Jane; Name:Marie; Most likely I need to reverse below code from Oracle Function to return similarity between strings as the result was the similarities [QueryResult] of the 2 strings I cannot use the procedure as I need

Advertisement