Re: Comparing Tables?

From: Tim Hall <tim.hall_at_spam.begone>
Date: 1997/11/13
Message-ID: <346af55d.12422225@69.0.9.9>#1/1

On Thu, 13 Nov 1997 08:34:30 GMT, mhunter_at_iadfw.net (M. Hunter) wrote:

> Is there an Oracle command or utility to compare the data in 2
>tables (same structure) and report any differences.
> Thanks in Advance

Try

SELECT * FROM table1
MINUS
SELECT * FROM table2;

followed by

SELECT * FROM table2
MINUS
SELECT * FROM table1;

Of course, if the tables aren't exactly identical, with the columns created in the same order, you will have to replace '*' with the column list.

---

Tim Hall, Indus International (was TSW International)

http://www.tswi.com
http://www.indusgroup.com

Replace domain name with the domain from the first URL before replying via email! Received on Thu Nov 13 1997 - 00:00:00 CST