Re: comparing two table

Try this to compare table1 with table2:

 select * from table1
 minus
 select * from table2;

as well as the reverse:

 select * from table2
 minus
 select * from table1;

I assume the column order of the tables created is same, else you need to replace the '*' with the column names.

-Madhu S

"alainc" <alain2208_at_caramail.com> wrote in message news:<b05rs8$9fq$1_at_s1.read.news.oleane.net>...
> Hello,
> i need to compare two table contents in two database (replication problem)
> so i need to compare not only one column but all.
> is there something easy to do not comparing all the column with his
> conuterpart on the other database?
> because i need to compare more than one table and that will be very long to
> make the query.
>
> thanks
>
> Alain
Received on Thu Jan 16 2003 - 13:42:53 CST