Skip to content
Advertisement

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

enter image description here

I cannot use the procedure as I need this SQL script to run in Oracle Fusion

Advertisement

Answer

Would this help?

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement