I think the view you need to query is dba_tab_columns instead of dba_tables.
-BMM
"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message
news:a6dh6s$l3k$1_at_bob.news.rcn.net...
> Select COLUMN_NAME, count(column_name), table_name
> FROM DBA_TABLES
> group by column_name
> having count(column_name) > 1
>
>
> "Halbert09" <junk01_at_optonline.net> wrote in message
> news:338ccebe.0203090848.5e82ee14_at_posting.google.com...
> > What SQL+ query would show me those tables that contain columns whose
> > names match the column-names of columns in other tables of the same
> > schema, and list the tables and matching column-names? Thanks for
> > your help.
> >
> > Harold
>
>
Received on Sat Mar 09 2002 - 13:23:54 CST
