Re: Best way to compare contents of two tables?

Lindsberger Franz wrote:
>
> The Mailman wrote:
> >
> > What is the best way to compare the contents of two tables to ensure that
> > their data exactly reflects each other?
> >
> > Thanks for any info regarding this topic.
> >
> > Joe
>
> Try this:
> write a PL/SQL-Procedure using records. Fetch your TABLE1
> into RECORD1 and TABLE2 into RECORD2 and compare them
> (IF record1 = record2) THEN ....
> good luck from AUSTRIA

That doesn't work. You can't compare records with a simple = sign. If anyone at Oracle is listening, it sure would be nice, though.

-- 
Joe Rogers
Intelligent Information Systems, Inc.
joer_at_renewal-iis.com