Oracle SQL script to compare columns differences in two tables

$0
=
$0
+
$0
No specific Bitcoin Bounty has been announced by author. Still, anyone could send Bitcoin Tips to those who provide a good answer.
0

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!

Tags:

1 Answer - total earned - 2.0578 mBTC ($1.4 USD)

1
=
3
=
$1.4
3 tips with total amount of 2.0578 mBTC($1.4 USD) have been sent by Anonimous

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

enter image description here

SEND BITCOIN TIPS

thanks Alex ...

Thx)

Alex, thanks for posting your answer

1

Post Answer


Will Bitcoin Tipping become a new Internet Culture?


Please share our story! THANK YOU!