Compare Tables Tool?

[Quoted] Hi All,

[Quoted] Wondering if there is anything around which if given two tables of the exact [Quoted] same structure will produce a text file with the SQL statements to make them [Quoted] both the same.

For example:

Consider two schemas, BEFORE and AFTER, with the same structures. Both contain a [Quoted] table, TABLE1 of the following structure:

TABLE1 ( ID, NAME ) Example 1:

BEFORE.TABLE1 ( ID, NAME ) = '1', 'Simon' AFTER.TABLE1 ( ID, NAME ) = '1', 'Simon Moy'

DIF: UPDATE TABLE1 SET NAME = 'Simon Moy' WHERE ID = '1'

BEFORE.TABLE1 ( ID, NAME ) =
AFTER.TABLE1 ( ID, NAME ) = '2', 'Leo Ng'

DIF: INSERT INTO TABLE1 ( ID, NAME ) VALUES ( '2', 'Leo Ng' )

BEFORE.TABLE1 ( ID, NAME ) = '3', 'Russell Pegler' AFTER.TABLE1 ( ID, NAME ) = DIF: DELETE FROM TABLE1 WHERE ID = '3'

To repeat above: Does Oracle supply a tool which can output the differences between the two schemas in SQL terms (see example below)?

And if so...
Can the tool be configured to automatically update the 'BEFORE' view after creation of the differences?
Does the tool work with LONG fields?
Can the tool examine all required tables and columns across two schemas based on [Quoted] some input definition?

Any help on this appreciated.

Regards,
Rowan McCammon.

-- 
[Quoted] Remove the anti-spamming thingy from my email address to reply to me.

The opinions expressed are my own and do not represent the opinions 
of my company.