OraFAQ Forum: SQL & PL/SQL » How to compare two tables?

Home » SQL & PL/SQL » SQL & PL/SQL » How to compare two tables? (Oracle 9i, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to compare two tables? [message #385172]

Fri, 06 February 2009 18:16

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.

Report message to a moderator

Re: How to compare two tables? [message #385174 is a reply to message #385172]

Fri, 06 February 2009 18:51

BlackSwan
Messages: 26766
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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The differences are (tab1 minus tab2) union all (tab2 minus tab1).

Regards
Michel

Report message to a moderator

Re: How to compare two tables? [message #385186 is a reply to message #385181]

Sat, 07 February 2009 01:39

krishna.kanigelpula
Messages: 12
Registered: August 2008
Location: Sydney

Junior Member

Thanks for the response. I will try this logic.

Cheers,

KK

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 13 00:55:01 CST 2024