Easiest way is use MINUS to see the diffrence between two tables.
select * from table newA
MINUS
select * from table oldA;
Anwer
streamline wrote in message ...
>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 Fri Oct 12 2001 - 16:46:27 CDT
