Comparing data between 2 tables...

From: Joe <RappaJ_at_nycha.nyc.gov>
Date: 3 Mar 2003 13:39:45 -0800
Message-ID: <ab8e8633.0303031339.58a3e6b0@posting.google.com>

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.

Thanks,
Joe Received on Mon Mar 03 2003 - 15:39:45 CST