| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Comparing Tables?
M. Hunter wrote:
> Is there an Oracle command or utility to compare the data in 2
> tables (same structure) and report any differences.
You could always try
( select * from tab1 minus select * from tab2 )
union
( select * from tab2 minus select * from tab1 )
Regards,
Ian Received on Fri Nov 14 1997 - 00:00:00 CST
 |
 |