Friday, August 21, 2015

Oracle Query to check whether difference in column names of 2 tables

select column_name,DATA_TYPE from (select column_name,DATA_TYPE from all_tab_cols where table_name='FIRST_TABLE_NAME' order by internal_column_id asc)
minus
select column_name,DATA_TYPE from (select column_name,DATA_TYPE from all_tab_cols where table_name='SECOND
_TABLE_NAME' order by internal_column_id asc);

No comments:

Post a Comment