Re: script to compares values in a table

From: George Barbour <gbarbour_at_csc.com>
Date: Tue, 9 Oct 2001 15:06:08 +0100
Message-ID: <3bc30150@pull.gecm.com>

Select * from tab_one
minus
Select * from table_two;

Page 3-15 Oracle8i Release 8.1.5
SQL Reference, Volume 1.

HTH
George Barbour.
"streamline" <small_bore_at_hotmail.com> wrote in message news:b1e9034f.0110090514.5407540f_at_posting.google.com...
> I have an idea to compare values (the data) in two tables before and
> after migration between oracle 8 and oracle 8i.
>
> For example, to compare the values in the table before migration with
> the values in the same table after migration to check that the data is
> the same.
>
> could something be knocked up quickly in pl-sql?
>
> does anyone have any ideas on how to write the code?
>
> many thanks!
Received on Tue Oct 09 2001 - 09:06:08 CDT