Home » SQL & PL/SQL » SQL & PL/SQL » How to compare two tables? (Oracle 9i, Windows XP)
How to compare two tables? [message #385172] Fri, 06 February 2009 18:16 Go to next message
krishna.kanigelpula
Messages: 12
Registered: August 2008
Location: Sydney
Junior Member
Hi Forum,

I am having a table, with 3 hundred thousand rows and every month I will get a refresh of the data. The new data I will create another table called TAB2. My requirement is to compare two tables and need to find count of the difference.

Any help with my above request is highly appreciated.

Thanks heaps in advance.

KK.



Re: How to compare two tables? [message #385174 is a reply to message #385172] Fri, 06 February 2009 18:51 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

> need to find count of the difference.
How do you define/identify EXACTLY what constitute a difference between the 2 tables?

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

[Updated on: Fri, 06 February 2009 18:52]

Report message to a moderator

Re: How to compare two tables? [message #385181 is a reply to message #385172] Sat, 07 February 2009 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The differences are (tab1 minus tab2) union all (tab2 minus tab1).

Regards
Michel
Re: How to compare two tables? [message #385186 is a reply to message #385181] Sat, 07 February 2009 01:39 Go to previous message
krishna.kanigelpula
Messages: 12
Registered: August 2008
Location: Sydney
Junior Member
Thanks for the response. I will try this logic.

Cheers,

KK
Previous Topic: partitions (merged)
Next Topic: unable to create table
Goto Forum:
  


Current Time: Tue Dec 06 06:38:49 CST 2016

Total time taken to generate the page: 0.20493 seconds