取出两个表(如A、B两表)中相同字段,如:
select column_name
from
(select column_name
from ALL_TAB_COLUMNS
where owner = (select user from dual)
and TABLE_NAME = 'A') a,
(select column_name
from ALL_TAB_COLUMNS
where owner = (select user from dual)
and TABLE_NAME = 'B') b
where a.column_name = b.column_name