3,494
社区成员




select table_name
from dba_tables t
where owner='SCOTT2'
and exists(
select 1 from
(select * from dba_tab_cols where owner='SCOTT2') a full join
(select * from dba_tab_cols where owner='SCOTT1') b
on a.table_name=b.table_name
and a.column_name=b.column_name
where nvl(a.table_name,b.table_name)=t.table_name
and (a.column_name is null or b.column_name is null))