Need an Oracle script to quickly compare two tables and identify columns that are different i.e. columns that are present in one table and missing in the other table, thanks!
Here you go. Note that we use FULL OUTER JOIN to return columns that are missing on both sides of the join
select t1.column_name t1, t2.column_name t2 from (select * from all_tab_columns where table_name = 'TABLE_ONE') t1 full outer join (select * from all_tab_columns where table_name = 'TABLE_TWO') t2 on t1.column_name = t2.column_name