Oracle 同实例中两个不同owner的表字段比较脚本

select a.TABLE_NAME,        a.COLUMN_NAME as  acol,         b.COLUMN_NAME as bcol,         a.DATA_TYPE as adt,        a.DATA_LENGTH as adl,        b.DATA_TYPE as bdt,        b.DATA_LENGTH as bdlfrom (        (select a.TABLE_NAME,                a.COLUMN_NAME,                a.DATA_TYPE,                a.DATA_LENGTH         from DBA_TAB_COLUMNS a         where a.OWNER = '<owner1>'              and a.TABLE_NAME='<table_name>'        ) a left join         (select a.TABLE_NAME,                a.COLUMN_NAME,                a.DATA_TYPE,                a.DATA_LENGTH         from DBA_TAB_COLUMNS a         where a.OWNER = '<owner2>'              and a.TABLE_NAME='<table_name>'        ) b on a.COLUMN_NAME = b.COLUMN_NAME)