Is any way to compare "the same table" in two different environments (such as Prod & Dev) to make sure script is the same and to show any difference? I am not talking the Toad Schema comparison. For example, table ABC has a field with VARCHAR2(10 BYTE) in Prod, the “same” table ABC has the same field with VARCAHR2(11 BYTE) in Dev. I need table name, field name display in a file or report. The other example, if table ABC in Prod has “CREATE OR REPLACE SYNONYM…” but table ABC in Dev without “CREATE OR REPLACE SYNONYM…”. Is any way I can write something to get the discrepancies to show in a report or a file? The same thing for packages, triggers, etc.
Thank you very much.