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!

Using jaro_winkler_similarity - Possible error

532672Sep 8 2006 — edited Aug 31 2008
I am using the utl_match function jaro_winkler_similarity on a table in a Oracle 10g database installation in order to find possible duplicates.
In short, the sql statement is:
select
p1.id, p1.codi, p2.id, p2.codi
from
empreses p1, empreses p2
where
p1.id<>p2.id
and
utl_match.jaro_winkler_similarity(p1.codi,p2.codi)>=90;

There are 10000 tuples in this table which definition is:
describe empreses;
Name Null? Type
----------------------------------------- -------- ----------------------------
RELEVANCIA FLOAT(126)
ID NOT NULL NUMBER
DATA_ALTA DATE
CODI VARCHAR2(200)

The query ALWAYS ends with an error:
ERROR:
ORA-03113: end-of-file on communication channel

How could I trace this error? Is there any other function effectively enough to search duplicates?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2008
Added on Sep 8 2006
20 comments
8,206 views