select table_name, column_name
from user_tab_columns
where column_name in (select column_name
from user_tab_columns
group by column_name
...