Comparison between texts

[mello]

Someone has a function that compares a text with the other and brings me the difference between them.
Example:




Result:

Select all

linha   texto1                     |       texto2 
1       alguém tem uma funcao      |       alguém tem uma funcao    igual 
2       que compare um texto       |       que compare um texto     igual  
3       com o outro e me traga     |                                diferente 
4       a diferenca entre eles     |       a diferenca entre eles   igual

: D

[dr_gori]

I think this function is not so simple.
There is a program called Winmerge that does just that.

Since he is open-source, maybe you venture to open and find out how this comparison is done. I think the algorithm is well complex!
http://winmerge.sourceforge.net/

[Ricardo_Kaka]

In SQL Navigator, there is a function to do this:

- Flame View Difference

[gilbertoca]

Take a look at this link http://download-west.oracle.com/docs/cd ... sthref1936

from then you can create your function.

Gilberto