EXISTS

I want to know the column names that exists in more than one table; also, I want to know the table names where it exists. I tried this query and it took a long time and so I stopped it:

select table_name,column_name, data_length, data_type from user_tab_cols
where column_name in (select column_name from user_tab_cols group by column_name
having count (*) > 1)
order by column_name

When I try using EXISTS instead of IN, I get wrong results; it gives me the the column names even when it exists in only one table. select table_name,column_name, data_length, data_type from user_tab_cols
where exists (select column_name from user_tab_cols group by column_name
having count (*) > 1)
order by column_name

Please let me know what I am doing wrong? I am not very familiar with EXISTS Thank you in advance. Received on Mon Jul 07 2003 - 19:31:42 CEST