| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
(
select * from table1
minus
select * from table2
)
union all
(select * from table2
minus
select * from table1
)
The minus is needed both ways.
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
Received on Thu Jan 23 1997 - 00:00:00 CST
 |
 |