Came across an interesting Oracle supplied package called UTL_MATCH. It is used for comparing string values. If for example you want the user to be 90% exact when typing a certain string value you can use the function edit_distance_similarity and embed it into a program logic.
select UTL_MATCH.edit_distance_similarity ('programmer', 'programer')
from dual;
Detailed description of the package can be found here
Ni komentarjev:
Objavite komentar