Re: Oracle utility to quickly compare two tables

To cover all the differences you need to do it both ways, viz:

(
Select * from Schema1.Table1
MINUS
Select * from Schema2.Table2
)
union all
(
Select * from Schema2.Table2
MINUS
Select * from Schema1.Table1
)

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Mike Rose wrote in message ...
>
>Select * from Schema1.Table1
>MINUS
>Select * from Schema2.Table2
>
Received on Tue May 18 1999 - 14:53:20 CDT