Arrays in a function to calculate Levenshtein distance
540364Oct 19 2006 — edited Nov 7 2006Hi,
I'm trying to write a function to calculate the Levenshtein distance between two words. In order to do this I need 2 arrays of length(word1) in this function.
The solutions I found so far to create and use an array, typically use a table to store the items in the array. I'm not very thrilled by this solution, I'd rather use a varchar2(const) instead.
Does any one know a different solution to easily create and use arrays without having to preform difficult operations each time I want to update an item in the array?
Many thanx