Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to compare contents of two tables?
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
Received on Wed Jan 22 1997 - 00:00:00 CST