Re: Data differences in two schemas

Hello,

A conservative programmer like me would use plain SQL:

(

SELECT ‘<', t.* FROM schema1.employee t
MINUS
SELECT ‘<', t.* FROM schema2.employee t
)
UNION ALL
(

SELECT ‘>', t.* FROM schema2.employee t
MINUS
SELECT ‘>', t.* FROM schema1.employee t
)
ORDER BY 2, 3, 4, 1
/

Yes, the arrow-signs are as intended.

As this query does not mention column names, you may easily generate it for all tables (make a two-stage SQL script)

Edzard Pasma Received on Tue Jun 11 2002 - 14:20:31 CDT