Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Selecting SIMILAR, not the same records (PROBABLE) duplicates

Re: Selecting SIMILAR, not the same records (PROBABLE) duplicates

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Sep 2006 12:47:38 -0700
Message-ID: <1157572055.322076@bubbleator.drizzle.com>


kroger wrote:

> I'm a Java programmer
>
> Thanks again,
> BR,
> Kroger

Not to be too cruel but this explains much.

 From the DBMS side my basic premise is that if the data is not constrained a part of a primary key, unique constraint, foreign key, check constraint, or by a trigger ... it is a memo field and one should expect it to contain nothing but garbage.

That seems to be your current situation.

Get someone to apply some SQL or PL/SQL to the problem.

-- 
Puget Sound Oracle Users Group
Received on Wed Sep 06 2006 - 14:47:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US