Re: Compare rows in diffrent table

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 11 Jun 2002 15:04:09 GMT
Message-ID: <3D061164.13265514@exesolutions.com>

vikram morey wrote:

> Dear All
>
> I have a problem.
>
> I want to compare rows in the tables in my schema. If any two rows are
> identical by any combination in any given table, it should not allow
> me to delete the same.
>
> Can someone help me out, by giving a solurtion for that. I am thinking
> of writing a procedure using minus and union all, or writing a before
> delete trigger.
>
> Which will be better and how to do it.
>
> Thanks,
>
> Vikram

If two rows in the same table are identical you don't have a primary key constraint on the tables. Is that the case?

There have been numerous examples of deleting duplicate records in this group so far this year. Search the Google archives.

Daniel Morgan Received on Tue Jun 11 2002 - 10:04:09 CDT