Re: comparing two table

thanks in fact i found out myself

but i tried

select * from table1
minus
 select * from table2
Union
  select * from table2
 minus
  select * from table1;

it's not working it gives me only the last one

does anybody knows why? that's only for personal knowledge

thanks

"MS" <qcom_at_attbi.com> a écrit dans le message de news: a2b6d46b.0301161142.12b167b4_at_posting.google.com...
> 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 Fri Jan 17 2003 - 04:09:19 CST