Re: EXISTS

From: varol cavdar <varol_at_bilisim-ltd.com.tr>
Date: 7 Jul 2003 23:58:33 -0700
Message-ID: <e014aa93.0307072258.63ce012e_at_posting.google.com>

hi,
  here is the possible solutions

 select
  table_name,
  column_name,
  data_length,
  data_type
 from
  user_tab_cols A
 where exists (select column_name

                from   user_tab_cols
                where  column_name = a.column_name
                group by column_name
                having count (*) > 1)

 order by column_name

select distinct

  a.table_name,
  a.column_name, 
  a.data_length, 
  a.data_type 

from
  user_tab_cols a,
  user_tab_cols b
where

  a.column_name = b.column_name and
  a.data_length = b.data_length and
  a.data_type = b.data_type and
  a.table_name <> b.table_name

order by column_name, table_name; Received on Tue Jul 08 2003 - 08:58:33 CEST