Re: tool to visual check differences in output from 2 sql queries

Have you tried the following:

select <whatever columns>
  from table1
minus
select <whatever columns>
  from table2_at_database2

Don't know what the data looks like, but, if the data is same in each table, the statement above should find the differences.

HTH
Pete's

dupolas_at_yahoo.com (geoffrey) wrote in message news:<9ac1661.0309100213.2a066f2e_at_posting.google.com>...
> Hi,
>
> I would like to compare data in two different databases to see if all
> data returned from "sql statement1" from database1 is available in the
> results of "sql statement2" from database2.
>
> I have found some tools that can do table comparisons between two
> databases, but unfortunately it can not be used in our case, since
> data of different tables from database1 is placed in one table/other
> named table in database2.
>
> We are using Oracle..
>
> Does anyone of you know if there's a tool available to do this
> visually?
>
> summary: looking for a tool to compare output from sql statement 1
> with output from sql statement 2 in a visual way.....
>
> greetz,
>
> geoffrey
Received on Wed Sep 10 2003 - 08:25:25 CDT