Re: Best way to compare records ?

From: Ed Prochak <edprochak_at_magicinterface.com>
Date: Mon, 22 Oct 2001 01:08:25 GMT
Message-ID: <3BD39C72.AF255E4F@magicinterface.com>

CrazyIvan wrote:
>
> What would be the best way to compare records field by field in PL/SQL?
> I have to update a table with several thousand records, some new, some the
> same, but some altered.
> Every record has to be compared field by field (not all fields, but most of
> them) to detect changes.
>
> Thanx ia.

I'd say the answer is: it depends!

I don't believe there is an answer specific to ORACLE. This is really dependent on your application data. I say this from the experience of working thru these issues right now on my current assignment.

If you have one source that you know is correct, then is should be a simple procedure.
If your problem is like mine, identifying which of multiple systems have the right data, then you may be stuck with lots of manual data review.
If you problem is merely the issue of applying a delta, then it also should be easy.

I know this doesn't really solve your problem, but remember, I'm stuck in situation #2! Received on Sun Oct 21 2001 - 20:08:25 CDT