Re: Comparing data between 2 tables...

> Hello,
>
> Can someone please give me some tips on a simple way to compare all
> columns and data on 2 tables in separate schemas in the same instance?
>
> I want to create a comparison report of, for example, MY.TABLE_SAL
> -vs- THEIR.TABLE_SAL. I want to make sure that when I load Joe
> Millionaires annual salary of $19,000 in MY.TABLE_SAL via sqlldr, they
> also take the full $19000 and not just $1900 when they extracted the
> data to be loaded into production.
>
> P.S. I'm not a DBA, so if some kind of DBA privies are needed for some
> kind of tool or Data Dictionary table, please let me know.
>
> Any tips provided is appreciated.

Something like

  select
    'theirs: ' whose, t.* from
      (select * from their.table_sal minus select * from my.table_sal) t   union
  select
    'mine: ', u.* from
      (select * from my.table_sal minus select * from their.tablep) u;

hth

Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html