Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to compare data
On Sun, 1 Oct 2006 23:37:30 -0400, "klabu" <klabu_at_gmail_dot_com>
wrote:
>Given 2 tables: emp1, emp2,
>- identical structure
>- identical number of rows (assuming with identical PK values)
>But other data are different
>
>You need to find the differences....
>
>How would you
>- compare & find the differences
>- and show them ?
>
>thx
>
join the 2 tables on their pks and test in the where clause the other
columns for inequality.
Homework is not supported here.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Oct 02 2006 - 00:05:15 CDT