Oracle-L: RE: How to compare data between two tables

From: Ferenc Mantfeld <fmantfeld_at_siebel.com>
Date: Tue, 18 Jun 2002 03:38:27 -0800
Message-ID: <F001.00480178.20020618033827@fatcity.com>

MINUS, INTERSECT ? Pick your weapons.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia

-----Original Message-----
Sent: Monday, 17 June 2002 4:08 PM
To: Multiple recipients of list ORACLE-L

I have two tables which have the same column names but some column has different data than another. I'd like to compare data stores in these two tables to get differences. Is there a SQL command that helps me to compare the data between two tables?

Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nguyen, David M
INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ferenc Mantfeld
INET: fmantfeld_at_siebel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------