Re: Searching for SQL Script to compare tables
From: Raj Gabriëlse <gabrielse_at_ctbede.nl>
Date: 1998/02/15
Message-ID: <34E75524.61FF404F_at_ctbede.nl>#1/1
Date: 1998/02/15
Message-ID: <34E75524.61FF404F_at_ctbede.nl>#1/1
I meant structure wise..;) thru a (pl/)sql script, NOT some tool like D2K or so...
Don Fraser wrote:
> Raj Gabriëlse wrote in message <34E6DC18.2304CD02_at_ctbede.nl>...
> >Hi all,
> >
> >I'm looking for a script that can compare two tables to each other and
> >list the differences.
>
> Use the minus command
>
> select all rows from table1
> MINUS
> select all rows from table2
Received on Sun Feb 15 1998 - 00:00:00 CET