oracle 表结构对比差异SQL脚本

select m.owner,
       m.table_name,
       m.column_id,
       m.column_name,
       m.data_type,
       m.data_length,
       n.owner,
       n.table_name,
       n.column_id,
       n.column_name,
       n.data_type,
       n.data_length
  from (select owner,
               table_name,
               column_id,
               column_name,
               data_type,
               data_length
          from dba_tab_columns
         where owner = &要比较的表所在用户_a /*"示例：'sys'"*/
           and table_name = &要比较的表名_a /*示例：'emp'*/
        ) m
/* right join*/ left join (select owner,
                    table_name,
                    column_id,
                    column_name,
                    data_type,
                    data_length
               from dba_tab_columns
              where owner = &要比较的表所在用户_b /*"示例：'system'"*/
                and table_name = &要比较的表名_b /*示例：'emp'*/
             ) n
    on m.column_id = n.column_id
   and m.column_name = n.column_name
   and m.data_type = n.data_type
   and m.data_length = n.data_length
 order by m.table_name, m.column_id;