Wanted help!!
I have a task where i need to compare two tables (2 or 3 columns ) from different databases.the columns to compare are not ids. they are columns like name, description, status etc, basically varchar2 data type.
When both the tables match, i need to update the mapping column as mapped.when not matched, i need to update as not matched.
i need to pull a report for the data which is not matched.
can you please help me the best approach for this.
Thanks
AK