I have two similar tables in oracle in two different databases. For example : my table name is EMPLOYEE and primary key is employee id. The same table with same columns(say 50 columns are is avlbl in two databases and two databases are linked.
I want to compare these two tables column by column and find out which records are not matching. i want the specific column in each row in two tables that are not matching.
Used full outer join -- But it will not show - if its not matched -
SQL> desc aaa - its a table Name Null? Type
A1 NUMBER B1 VARCHAR2(10)
SQL> desc aaav -its a view Name Null? Type
A1 NUMBER B1 VARCHAR2(10)
SQL> select a.column_name,b.column_name from dba_tab_columns a full outer join dba_tab_columns b on a.column_name=b.column_name where a.TABLE_NAME='AAA' and B.table_name='AAAV';
COLUMN_NAME COLUMN_NAME
A1 A1 B1 B1
