Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Levenshtein Distance formula; arrays

260689Apr 19 2002
I am to write a stored procedure that returns the Levenshtein Distance between 2 strings (similarity ratio). According to sample code designed for Java or VBA, intermediate calculation results are stored in 2-dimensional Arrays, e.g. value_array[1][5] = 7

Has anyone an idea on how
a) to implement the Levenshtein Distance formula in PL/SQL, or
b) how to properly use Arrays in PL/SQL (which seem not to be supported)

Thanks in advance for any kind of help I can get on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2002
Added on Apr 19 2002
5 comments
1,582 views