UserMB wrote:There is no way you can do this with just names. Names simply aren't a UID. You need other factors for certainty.
can you advise what the best approach would be to uniquely identify the same people?
so far i have only found this functions :utl_match.jaro_winkler_similarity and SOUNDEXThose are the two generic functions that Oracle offers out of the box. Unless you're on 11g in which case you should have a look at the Name Search functionality which comes with Oracle Text. [url http://docs.oracle.com/cd/E11882_01/text.112/e24435/search.htm#CCAPP9534]Find out more.