Re: Comparing tables

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 25 Aug 1999 19:15:58 +0200
Message-ID: <935601390.25928.0.pluto.d4ee154e@news.demon.nl>

You could use MINUS to do that, provided datatypes are the same select col1, col2
from table1
minus
select col1, col2
from table2
will return the rows from table1 where the columns don't match

Hth,

Sybrand Bakker, Oracle DBA

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:37c416f1.72961794_at_news.earthlink.net...
> Hi folks,
>
> Is there are a function/procedure to compare tables and contents?
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Wed Aug 25 1999 - 12:15:58 CDT