Oracle SQL script to compare columns differences in two tables

Oracle SQL script to compare columns differences in two tables 14 Jun 2016

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

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: oracle

Edited Apr 28'16 at 10:26

lampego1@qrid

Created Apr 12'16 at 16:00

alex@qrid

ADD COMMENT | SEND TIPS

1 Answer

$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

Edited Apr 12'16 at 16:04

alex@qrid

Created Apr 12'16 at 16:04

alex@qrid

ADD COMMENT

Anonymous Jun 14'16 at 01:37

0.2378 mBTC | 0.16 USD → alex@qrid

thanks Alex ...

Anonymous Jun 14'16 at 09:56

0.35 mBTC | 0.24 USD → alex@qrid

Thx)

Anonymous Jun 14'16 at 19:54

1.47 mBTC | 1 USD → alex@qrid

Alex, thanks for posting your answer

Too many commands? Learning new syntax?

FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.

Boost your productivity with FavScripts.com!

BitExperts