Compare to string
Compare to string using regular expression. The result is a grade between 0-100.
Last updated:
Warning: Review and test in a non-production environment before running.
create or replace function compare_strings(
p_char1 in VARCHAR2,
p_char2 in VARCHAR2
) return NUMBER
is
v_sql VARCHAR2(1000);
v_grade NUMBER;
begin
v_sql := 'SELECT UTL_MATCH.JARO_WINKLER_SIMILARITY(TRIM('''||p_char1||'''),TRIM('''||p_char2||''')) FROM DUAL';
EXECUTE IMMEDIATE v_sql INTO v_grade;
RETURN v_grade;
end;
/